ExcelBanter - shortcut key to select all worksheets?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - shortcut key to select all worksheets? (https://www.excelbanter.com/excel-discussion-misc-queries/190715-shortcut-key-select-all-worksheets.html)

annoni

shortcut key to select all worksheets?

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

Gord Dibben

shortcut key to select all worksheets?

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

On Tue, 10 Jun 2008 11:15:00 -0700, annoni
wrote:

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

Mike H.

shortcut key to select all worksheets?

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

Sub doit()

Sheets.Select
End Sub

"Gord Dibben" wrote:

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

On Tue, 10 Jun 2008 11:15:00 -0700, annoni
wrote:

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

All times are GMT +1. The time now is 11:11 PM.