Navigation between worksheets
It is often the case that when we are developing Dashboard Design dashboards, we run out of room for our worksheet tabs. We then have to scroll through each tab in order to get to the one that we want; this is kind of a pain. To access tabs that are not visible, we are used to pressing the arrow keys to move to the desired tab.
How to do it...
- To have all tabs displayed in one menu, right-click on the tab at bottom, left-hand side navigation area. You will then see the list of tabs that you can choose from.
- You can also use Ctrl + PageUp, which will move to the previous sheet in your workbook.
- Ctrl + PageDown will activate the next sheet in the workbook.
How it works...
The methods explained work by allowing developers to move between worksheets more quickly. Being able to quickly right-click and show 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 savings benefits for those who are comfortable with using the keyboard to perform all their actions.