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