Quickly select all sheet tabs in your Excel workbook with a single action.
You can also do this by right-clicking a sheet tab and choosing 'Select All Sheets', but many users are unaware of this option.
Tip: If you use this frequently, add it to your 'My Tools & Shortcuts' menu and assign a shortcut for faster access.
Click › Select › 15. Select All Sheets
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords to help you find this tool:
Select all sheets in Excel, Select all sheet tabs, Highlight all sheets in a workbook, Excel shortcut to select all sheets, Activate all worksheets in Excel, Select all sheets at once, Quickly select all tabs
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.
ASAP Utilities helps you save time and do what Excel alone can't.
You can get started right away. No training needed.
Most users start with a few tools. Many end up using ASAP Utilities daily.
Used by teams in 28,500+ organizations.
Start saving time in Excel with practical tools you can use right away.
No sign-up required.
Free 90-day trial