Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink in cells....how to activate it with out a mouse homer Excel Discussion (Misc queries) 0 November 22nd 06 02:10 AM
how to activate a drop down menu in spreed sheet with space bar? Raza Excel Discussion (Misc queries) 0 April 20th 06 05:21 PM
How do I activate the right mouse click in Excel? Kcm Excel Discussion (Misc queries) 0 March 28th 06 08:14 AM
Using mouse wheel to scroll drop down rfielack Excel Discussion (Misc queries) 0 January 14th 06 11:01 PM
No Mouse - How to access drop down boxes jayd77 Excel Discussion (Misc queries) 2 December 13th 05 11:55 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"