Switch Tabs (Worksheets) (Excel Shortcut)

In Excel, the user can use multiple tabs within a workbook to enter 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 switch between multiple tabs (worksheets) within a workbook.

Steps to Switch Tabs Using Keyboard Shortcut

1. 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.
2. 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

1. The user needs to press the “PgDn” or PgUp” keys multiple times to switch to multiple tabs until he moves to the required tab.
2. 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