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.