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

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.

主站蜘蛛池模板: 确山县| 台南县| 富蕴县| 罗山县| 兖州市| 巫山县| 达州市| 长寿区| 元朗区| 阆中市| 西华县| 洪洞县| 涞源县| 那坡县| 东至县| 通渭县| 阜新市| 简阳市| 海安县| 资中县| 房产| 霍山县| 常宁市| 罗甸县| 佛教| 谷城县| 金沙县| 卢氏县| 广安市| 阿克陶县| 十堰市| 榆树市| 常宁市| 滨州市| 孟津县| 江山市| 栖霞市| 十堰市| 雷州市| 嘉禾县| 和平县|