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.
Leave a Reply