Switch Tabs (Worksheets) | Keyboard Shortcut | Microsoft Excel

HomeExcel Keyboard ShortcutsSwitch Tabs (Worksheets) | Keyboard Shortcut | Microsoft Excel

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:

keyboard-shortcut-to-switch-tabs-towards-right

Ctrl + PgDn (Page down) – To move towards the right tabs

keyboard-shortcut-to-switch-tabs-towards-left

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

Excel Shortcuts Cheat Sheet (PDF)