Working with Multiple Tabs

Do you ever work with an Excel workbook that has multiple worksheets (tabs)? If you do, you may want to take note of this quick shortcut.

If you’re using your mouse to click on things within the worksheet, then it may make sense to simply use the mouse to click on the desired tab. However, if you’re like me, your hands are on the keyboard most of the time.  Therefore to navigate between tabs, whether its for formulas or simply comparing data (there’s a formula for that!) it is MUCH easier and quicker to simply press the “Ctrl - Page Up” or “Ctrl - Page Down”.

If you would like to navigate one tab to the left, you press “Ctrl - Page Up”. If you would like to navigate one tab to the right, you press “Ctrl - Page Down”. It really can’t be simpler!

Do you find this useful? Post a comment below and let me know what you think!