Changing the Active Worksheet using the Keyboard in Excel
We often need to change the worksheet being viewed. We generally do this by clicking with the mouse on the sheet tab of the worksheet to be made active. However, there are also a couple keyboard shortcuts available, which will allow you to view the next or previous worksheet. These shortcuts are very helpful because you can move through the sheets really quickly without any movement of the mouse.
- Next worksheet Ctrl + Page Up
- Previous worksheet Ctrl + Page Down