Connecting Technology and Business.

Switching between worksheets

Toggling between multiple worksheets in a notebook you can always use your mouse or even the keyboard shortcuts. (For example, CTRL+PageUp activates the previous sheet in your workbook, while CTRL+PageDown activates the next one.) 

But what if you aren't sure of the one you want to look at? What if you want to see a list of all the worksheets in that particular workbook? It's simple: right-click the tab navigation buttons
Tab navigation 
... and a floating list of all the worksheets in the workbook will appear, as pictured below. Just click the one you want. (This is especially useful when sheet names are long.)


The names of all my worksheets