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

select all sheetsThe 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

Leave a Comment