In Excel, the user can use multiple tabs within a workbook to enter the multiple data and one can also receive the workbook having data in multiple tabs, so to switch between the tabs, the user can either switch manually using a mouse by clicking on each tab name or can switch the tabs using the keyboard shortcut.
In this tutorial, we have explained the shortcut to switching between multiple tabs (worksheets) within a workbook.
Keyboard Shortcut to Switch Tabs in the Excel
The Keyboard shortcut to switch between tabs is mentioned below:
Ctrl + PgDn (Page down) – To move towards the right tabs
Ctrl + PgUp (Page up) – To move back or towards left tabs
Steps to Switch Tabs Using Keyboard Shortcut
- Press and hold the “Ctrl” key and then press the “PgDn” key to move to the next tab towards the right of the current tab.
- Or Press and hold the “Ctrl” key and then press the “PgUp” key to move back to the left side tabs of the current tab.
Points to Remember
- The user needs to press the “PgDn” or PgUp” keys multiple times to switch to multiple tabs until he moves to the required tab.
- If the workbook has let’s suppose 15-20 tabs or more than that, then it is not a good option to switch using the keyboard shortcut because the keyboard shortcut does not switch directly to any tabs, it moves tab by tab. So, in that case, one can click on the navigator signs on the below scroll bar and using the keyboard up and down arrow keys, can select the tab (worksheet) and press enter to switch to that tab directly