shortcut key to select all worksheets?

[annoni]

Is there a shortcut key to select and deselect all worksheets in a file?
Thanks.

 

[Gord Dibben]

None that I know of other than CTRL + SHIFT + keep hitting pagedown until all
are selected.

The CTRL + pageup to unselect all but one.


Gord Dibben MS Excel MVP

 

[Mike H.]

Put a shortcut key on this macro and you can do it:

Sub doit()

Sheets.Select
End Sub