Tom’s Tutorials For Excel: Shortcuts to Select the Next, Many, or All Sheets
Here are a few shortcut tips for selecting worksheets.
Ctrl+PageDown keys will select the next (to the right) visible sheet.
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
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
• Right-click on any sheet tab, and left-click on Select All Sheets.