How to access dropdown list using keyboard?

[Ziad]

Hi

Can anyone please tell me how to access the dropdown lists I create using
the "validation" window from the "Tools" menu?

I usually access it with the mouse, but when I have to enter a lot of data I
would rather use the keyboard as it is much faster. In Access I can access
dropdown lists through F4 but it doesn't work in Excel

Any idea?

Thanks

Z

 

[Earl Kiosterud]

Ziad,

I agree the keyboard is much faster. Try Alt-DownArrow. Then use the
DownArrow key to make your selection. Press Enter.

 

[aaron.kempf]

Excel just doesnt work as well as Access

 

[Ziad]

Thanks for the tip
it worked just fine
Ziad

Ziad,

I agree the keyboard is much faster. Try Alt-DownArrow. Then use the
DownArrow key to make your selection. Press Enter.