30 Advanced Excel Tips for 2026

Excel Champs / Excel Keyboard Shortcuts / Switch Tabs (Worksheets) (Excel Shortcut)
By Puneet Gogia (Microsoft MVP)

Switch Tabs (Worksheets) (Excel Shortcut)

Press Ctrl + Page Down to move to the next worksheet tab on the right, and Ctrl + Page Up to move to the one on the left. Each press moves one sheet, and hidden sheets are skipped.

On laptops where Page Up and Page Down share keys with the arrows, add Fn: Ctrl + Fn + Down Arrow on many models. The exact keys vary by keyboard, and Mac keyboards differ again, so test yours.

To jump straight to a sheet in a big workbook, right-click the navigation arrows at the bottom left, next to the first tab. The Activate dialog lists the sheets; pick one with the arrow keys and press Enter. From the keyboard, press F5, type a reference such as 'Sales 2025'!A1 and press Enter.

Ctrl + Tab switches between open workbooks, not sheets, so it does nothing useful when only one file is open.

Adding Shift (Ctrl + Shift + Page Down) selects the next sheet as well as the current one, which groups them. While Group shows in the title bar, anything you type lands on every selected sheet; right-click a tab and choose Ungroup Sheets to stop it.

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

In Excel, you can use multiple tabs (worksheets) within a workbook to enter data, and you can also receive workbooks that have data in multiple tabs. To switch between the tabs, you can either click on each tab name with the mouse or switch the tabs using a 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 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. You need to press the “PgDn” or “PgUp” key (while holding Ctrl) multiple times to move across multiple tabs until you reach the required tab.
  2. If the workbook has, let’s suppose, 15-20 tabs or more, then the keyboard shortcut is not a good option, because it doesn’t switch directly to a tab; it moves tab by tab. In that case, right-click on the navigation arrows at the left of the sheet tabs. This opens the Activate dialog box with a list of all the sheets, where you can use the up and down arrow keys to select the tab (worksheet) and press Enter to switch to that tab directly.
navigator-sign-on-below-scroll-bar

Switch Tabs on a Mac

In Excel for Mac, use Control + Page Down to move to the next sheet and Control + Page Up to move to the previous sheet. You can also use Option + Right Arrow and Option + Left Arrow. On a MacBook keyboard without Page Up and Page Down keys, press Fn with the Up or Down Arrow key instead of Page Up or Page Down.

Select Multiple Tabs with the Keyboard

If you add Shift to the same shortcut, Excel selects the tabs instead of just moving to them. Press Ctrl + Shift + PgDn to add the next tab to the selection, and Ctrl + Shift + PgUp to add the previous one. The selected sheets become a group, so anything you type now goes into all of them. To ungroup, click on any tab that is not selected, or right-click a tab and choose Ungroup Sheets.

Frequently Asked Questions

Why does Ctrl + PgDn not work on my laptop?

Many laptops have Page Up and Page Down on the arrow keys, so you need to hold the Fn key as well: Ctrl + Fn + Down Arrow for the next tab and Ctrl + Fn + Up Arrow for the previous one.

Does the shortcut skip hidden sheets?

Yes. Ctrl + PgDn and Ctrl + PgUp only move through the visible sheets. Hidden sheets are also left out of the Activate dialog box, so you need to unhide them first.

How do I switch between open workbooks?

Use Ctrl + Tab to move to the next open workbook window and Ctrl + Shift + Tab to move to the previous one. Ctrl + PgDn and Ctrl + PgUp only switch between the sheets of the same workbook.

Leave a Comment