Select All Worksheet Tabs

February 15th, 2005 | Categories: Shortcuts | Tags:
-->

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

selectallsheetsThe 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

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Vishwas Rathi
    February 19th, 2010 at 11:52
    Reply | Quote | #1

    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.

  2. Vishwa
    November 17th, 2011 at 12:50
    Reply | Quote | #2

    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