Switch Tabs (Worksheets) (Excel Shortcut)

Last Updated: January 10, 2024
puneet-gogia-excel-champs

- Written by Puneet

Latest Video Tutorial – 10 Excel Keyboard Shortcuts (Probably YOU are NOT Using)

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.

Keyboard Shortcuts to Switch Tabs in the Excel

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

  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
navigator-sign-on-below-scroll-bar