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!
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.
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.
Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy a full-featured 30-day FREE trial with no credit card required!Get It Now
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: