Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to activate drop down box using keystrokes not mouse
For example, let's say I have 'autofilter' at the top of my column called
'Date.' How do I use keystrokes instead of the mouse to activate the drop down box so that I can select different dates? Thanks. Leslie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to activate drop down box using keystrokes not mouse
Place yourself on the drop-downcell, hold down ALT and hit Down-arrow.....
Then release ALT and go down with just down-arrow. Happy navigations! "Lesliec4000" wrote: For example, let's say I have 'autofilter' at the top of my column called 'Date.' How do I use keystrokes instead of the mouse to activate the drop down box so that I can select different dates? Thanks. Leslie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to activate drop down box using keystrokes not mouse
Perfect! Thank you! I hope to be totally mouse-free someday.
Leslie "Jop Duyvendak" wrote: Place yourself on the drop-downcell, hold down ALT and hit Down-arrow..... Then release ALT and go down with just down-arrow. Happy navigations! "Lesliec4000" wrote: For example, let's say I have 'autofilter' at the top of my column called 'Date.' How do I use keystrokes instead of the mouse to activate the drop down box so that I can select different dates? Thanks. Leslie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to activate drop down box using keystrokes not mouse
I have the same desire to not-use the mouse if I can help it (keyboard
strokes are so much faster...!). So maybe you have a solution to the following: Having multiple workbooks open, how can I navigate from sheet to sheet in a workbook, other than to: - lift right shoulder and arm - move arm and hand over to the right - look to the right to locate the mouse - lower shoulder and arm - grab the mouse - look at the screen to locate the mousepointer - move underarm and hand to bring mousepointer to the desired tab - click on the tab - lift shoulder and right arm - look at the keyboard - move arm and hand to the left and reposition fingers over keyboard - look at the screen again... :-) There should be something just-about equal to: - move thumb to ALT, hold down and use finger to hit CTRL ...... Thanks in advance! Jop "Lesliec4000" wrote: Perfect! Thank you! I hope to be totally mouse-free someday. Leslie "Jop Duyvendak" wrote: Place yourself on the drop-downcell, hold down ALT and hit Down-arrow..... Then release ALT and go down with just down-arrow. Happy navigations! "Lesliec4000" wrote: For example, let's say I have 'autofilter' at the top of my column called 'Date.' How do I use keystrokes instead of the mouse to activate the drop down box so that I can select different dates? Thanks. Leslie |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to activate drop down box using keystrokes not mouse
From sheet to sheet in one workbook.....CTRL + Pageup or Pagedown
From one workbook to next workbook.....CTRL + F6 Gord Dibben MS Excel MVP On Fri, 26 Jan 2007 13:03:02 -0800, Jop Duyvendak ) wrote: I have the same desire to not-use the mouse if I can help it (keyboard strokes are so much faster...!). So maybe you have a solution to the following: Having multiple workbooks open, how can I navigate from sheet to sheet in a workbook, other than to: - lift right shoulder and arm - move arm and hand over to the right - look to the right to locate the mouse - lower shoulder and arm - grab the mouse - look at the screen to locate the mousepointer - move underarm and hand to bring mousepointer to the desired tab - click on the tab - lift shoulder and right arm - look at the keyboard - move arm and hand to the left and reposition fingers over keyboard - look at the screen again... :-) There should be something just-about equal to: - move thumb to ALT, hold down and use finger to hit CTRL ...... Thanks in advance! Jop "Lesliec4000" wrote: Perfect! Thank you! I hope to be totally mouse-free someday. Leslie "Jop Duyvendak" wrote: Place yourself on the drop-downcell, hold down ALT and hit Down-arrow..... Then release ALT and go down with just down-arrow. Happy navigations! "Lesliec4000" wrote: For example, let's say I have 'autofilter' at the top of my column called 'Date.' How do I use keystrokes instead of the mouse to activate the drop down box so that I can select different dates? Thanks. Leslie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink in cells....how to activate it with out a mouse | Excel Discussion (Misc queries) | |||
how to activate a drop down menu in spreed sheet with space bar? | Excel Discussion (Misc queries) | |||
How do I activate the right mouse click in Excel? | Excel Discussion (Misc queries) | |||
Using mouse wheel to scroll drop down | Excel Discussion (Misc queries) | |||
No Mouse - How to access drop down boxes | Excel Discussion (Misc queries) |