Shortcut key for dropdown list?
 

Hi,

Just wondering of there is a default keyboard shortcut key combination that
will make a cell that has data validation perform the dropdown for me. To
clarify, I'm talking about a keyboard way to push the little dropdown arrow
that displays when a cell that has validation list. I do not want to keep
grabbing the mouse just to click that dropdown arrow, just to get the list to
dropdown so I can make a selection (with the arrow keys of course).

I look forward to your reply.

Regards,
Brcobrem

Shortcut key for dropdown list?
 

Try this:

Hold down the [alt] key and press the DOWN arrow

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Brcobrem" wrote:

Hi,

Just wondering of there is a default keyboard shortcut key combination that
will make a cell that has data validation perform the dropdown for me. To
clarify, I'm talking about a keyboard way to push the little dropdown arrow
that displays when a cell that has validation list. I do not want to keep
grabbing the mouse just to click that dropdown arrow, just to get the list to
dropdown so I can make a selection (with the arrow keys of course).

I look forward to your reply.

Regards,
Brcobrem

Shortcut key for dropdown list?
 

Hi Ron,

You know, I tied every key combo that I could think of: except that one :-

Thanks !
Brcobrem


"Ron Coderre" wrote:

Try this:

Hold down the [alt] key and press the DOWN arrow

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Brcobrem" wrote:

Hi,

Just wondering of there is a default keyboard shortcut key combination that
will make a cell that has data validation perform the dropdown for me. To
clarify, I'm talking about a keyboard way to push the little dropdown arrow
that displays when a cell that has validation list. I do not want to keep
grabbing the mouse just to click that dropdown arrow, just to get the list to
dropdown so I can make a selection (with the arrow keys of course).

I look forward to your reply.

Regards,
Brcobrem