Excel Hack

Switch sheets in Excel shortcut (Ctrl + PgUp)

We will show you a shortcut key to move between sheets without using the mouse. Usually, when you want to switch between sheets, you click on the sheet tabs at the bottom of the screen, but you can use the shortcut keys to operate more smoothly. You can use the shortcut keys for switching sheets in both Windows and Mac.

Switch sheets shortcut

Ctrl + PgUp or Ctrl + PgDn

option + (Left Arrow key) or option + (Right Arrow key)

Use shortcut keys to switch between sheets

Learn how to use shortcut keys to move between sheets.

Total Time: 1 minute

Prepare a multi-sheet book

Prepare a multi-sheet book

Start the operation with the National, 2-digit sheet selected. Switch to the Metropolitan Areas sheet.

The sheet will switch

The sheet will switch

Hold down Ctrl and press PgDn three times to switch to the Metropolitan Area sheet.

Switch to another sheet

Switch to another sheet

Hold down Ctrl and press PgUp twice to switch to the National, 5-digit sheet. To move to a distant sheet, press the PgUp or PgDn multiple times.


Please send us your comments on this article.

Inline Feedbacks
View all comments