Select All Sheets

ASAP Utilities › Select  ›  16. Select All Sheets

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.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional search terms 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.

Get Started with ASAP Utilities 9

Start saving time in Excel with practical tools you can use right away.

  • No sign-up required.

  • Free 90-day trial