Worksheet Navigation in Excel

The other day I found myself switching frequently between three worksheets in an Excel workbook. Having to grab the mouse, select another worksheet tab, then switch my hand back to the keyboard became annoying, so I looked up the keyboard shortcuts.

Excel for Windows:

Ctrl+PgDn — takes you to the next worksheet
Ctrl+PgUp — takes you to the previous worksheet

Excel for Mac:

OPTION + RIGHT ARROW — takes you to the next worksheet
OPTION + LEFT ARROW — takes you to the previous worksheet

Navigation Shortcut with the Mouse

The worksheet tab controls come in handy with too many worksheets in the workbook.

Worksheet Tab Controls

Right-click on these controls and a pop-up list appears, then click on a sheet name to activate it.

Right-Click Sheet List

For more than 15 worksheets, at the bottom of the list you’ll see an entry for More Sheets…. Click to bring up an Activate dialog box that shows all the worksheets by utilizing a scroll bar.

Right-Click Sheet List More Sheets

I wish Microsoft would allow the pop-up list to be more than 15 sheets.

1 thought on “Worksheet Navigation in Excel”

  1. Pingback: Tweets that mention Worksheet Navigation in Excel | Excel Semi-Pro --

Comments are closed.