官术网_书友最值得收藏!

Navigating between worksheets

When developing dashboards it is a common problem to have to manually scroll through tabs when there are too many worksheets. To access tabs that are not visible, we are used to pressing the arrow keys to move to the desired tab.

Navigating between worksheets

How to do it...

  1. To have all tabs displayed in one menu, right-click on any of the arrow keys at the bottom, in the left-hand side navigation area. You will then see the list of tabs that you can choose from.
    How to do it...
  2. You can also use Ctrl + PageUp, which will move to the previous sheet in your workbook.
  3. Ctrl + PageDown will navigate to the next sheet in the workbook.

How it works...

This tip allows developers to quickly toggle between worksheets. Being able to quickly right-click and view a menu of all available tabs is faster than scrolling through each tab in order to reach tabs that are not visible. In addition, the ability to use a hotkey to cycle through each tab brings some time-saving benefits to those who are comfortable with using the keyboard to perform all their actions.

主站蜘蛛池模板: 分宜县| 田林县| 桂东县| 宣武区| 孟连| 彰化市| 宁陕县| 黑水县| 射洪县| 邓州市| 崇义县| 淮南市| 镇巴县| 夏邑县| 策勒县| 定陶县| 句容市| 疏勒县| 罗山县| 顺平县| 汝城县| 乐东| 平湖市| 十堰市| 眉山市| 敦煌市| 临城县| 本溪| 壶关县| 中宁县| 保德县| 沅陵县| 沂水县| 正安县| 格尔木市| 星座| 新宾| 凤山县| 宜昌市| 海阳市| 桐城市|