Worksheet Navigation in Excel

by Gregory on December 9, 2010

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.

Related Posts Plugin for WordPress, Blogger...

Comments on this entry are closed.

{ 1 trackback }

Previous post:

Next post: