Tom’s Tutorials For Excel: Shortcuts to Select the Next, Many, or All Sheets

Tom’s Tutorials For Excel: Shortcuts to Select the Next, Many, or All Sheets

Here are a few shortcut tips for selecting worksheets.

Pressing the Ctrl+PageDown keys will select the next (to the right) visible sheet.


Pressing the Ctrl+PageUp keys will select the previous (to the left) visible sheet.


To select individual sheets as a group, click their tab while pressing the Ctrl key.


All worksheets can be selected as a group by either of two ways:
• Select the first sheet tab, then click the last sheet tab while pressing the Shift key.
or
• Right-click on any sheet tab, and left-click on Select All Sheets.