Select All Worksheet Tabs
The long way to select all Worksheet Tabs:
1. Select the First Sheet in the Workbook
2. Hold down Shift Key
3. Select the last worksheet in the Workbook
The quicker way to select all Worksheet Tabs:
1. Right click any tab and choose:
Select All Sheets
To unselect all sheets:
1. Left click any individual tab or
2. Right click any tab and choose:
Ungroup Sheets
Didnt realise selecting all worksheets would be so simple. but it did the trick. I have excel file with 270 worksheets. All i wanted was to make the zoom %age 80 on all and obviously cant do that on each one separately, so visited this page and wow…..
Thanks very much.
Hi Vishwas, if you want to select all sheets of your workbook where the sheet number is huge, it will be very difficult to select manually. You can take help of VBA.
Just paste the below code under a command button Click Event. On clicking on that button1, all the sheets of the workbook will be selected.
========================================
Private Sub CommandButton1_Click()
Sheets.Select
End Sub
=========================================
Learn Excel Macro
how can I select all sheets and then unselect certain sheets or tabs? I want to select most of the tabs and it’s easier to select all and then unselect the ones I don’t need, is there a way to do it with a shortcut?