| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
shortcut key to select all worksheets?
Is there a shortcut key to select and deselect all worksheets in a file?
Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut key to cycle through worksheets in the same workbook | Excel Discussion (Misc queries) | |||
| keyboard shortcut for switching between worksheets?? | Excel Worksheet Functions | |||
| Shortcut toggle between worksheets in the same workbook? | Excel Worksheet Functions | |||
| How can switch with a shortcut between worksheets? | Excel Discussion (Misc queries) | |||
| What is the shortcut for switching between worksheets? | Excel Discussion (Misc queries) | |||
Linear Mode
