How to select multiple or all sheet tabs in Excel?
In general, we can easily select one sheet tab by clicking it on the Sheet Tab bar in Excel. However, sometimes you may need to select multiple or all sheet tabs at the same time, how could you get it done? There are two easy solutions for you!
Navigation Pane: quickly select and activate opening workbooks and their sheets in Excel
Kutools for Excel’s Navigation Pane lists all opening workbooks and corresponding worksheets vertically as below screenshots. (1) Clicking a workbook in the Workbook section will switch to this workbook window; (2) while clicking a worksheet in the Worksheet section will skip to open this worksheet.
Full Feature Free Trial 60-day!
Enable you to do smarter, faster and better
Kutools - the best office productivity tool brings
300 advanced features to Excel. Details... Download...
Office Tab - brings tabbed interface to Excel and Word, make your work much easier. Details...Download...
Select multiple or all sheet tabs with hotkeys
You can select multiple or all sheet tables with the Ctrl key or the Shift key in Excel.
Holding the Ctrl key, you can select multiple nonadjacent sheet tabs by clicking them one by one.
Holding the Shift key, you can select multiple adjacent sheet tabs by clicking the first sheet tab and the last one.
Select all sheet tabs by right-clicking menu
Apart from the Ctrl key or Shift key, you can also select all sheet tabs easily with the right-clicking menu in Excel.
Right-click any sheet tab in the Sheet Tab bar, and then select the Select All Sheets in the right-clicking menu.
Now you will see all sheet tabs are selected in bulk. See screenshot:
Excel Productivity Tools
300 powerful advanced features to Excel, enable you to do smarter, faster and better.
- No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
- Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds,
- Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
- 110,000 highly effective people and 300+ world-renowned companies' choice.
- 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by
50%, and reduces hundreds of mouse clicks for you every day!