Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping sheets with one hand in Excel
I have a user with only one arm, and she needs to be able to group worksheets
in Excel. I know that you can right-click a sheet tab and choose "Select all sheets" from the menu, but what if she needs to select/group non-adjacent sheets? She cannot Ctrl+click with just one hand. Any suggestions would be greatly appreciated! TIA, Steve Vincent IT Trainer |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping sheets with one hand in Excel
Hi Steve,
How about a VBA procedure that creates a list box of sheet names that you can select and group with the mouse. You could tie it to a command or toolbar button that could be run with a mouse click. HTH "Steve Vincent" wrote: I have a user with only one arm, and she needs to be able to group worksheets in Excel. I know that you can right-click a sheet tab and choose "Select all sheets" from the menu, but what if she needs to select/group non-adjacent sheets? She cannot Ctrl+click with just one hand. Any suggestions would be greatly appreciated! TIA, Steve Vincent IT Trainer |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Grouping sheets with one hand in Excel
CTRL-SHIFT-PGDN or CTRL-SHIFT-PGUP will group the current tab with the
one immediately next to it, and additional presses will group additional sheets. Unfortunately this method requires that sheets be next to each other- I wasn't able to work out a way to choose non-contiguous sheets. Sorry I couldn't be of more help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Access database to "populate" Excel Sheets | Excel Discussion (Misc queries) | |||
Opening multiple Excel files that contain varied selected sheets | Excel Worksheet Functions | |||
Updating, Deleting and inserting rows over two Excel Sheets | Excel Worksheet Functions | |||
Create New Microsoft Excel Worksheet Has 3 Sheets | Setting up and Configuration of Excel | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |