How to access dropdown list using keyboard?

  • Thread starter Thread starter Ziad
  • Start date Start date
Z

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
 
Ziad,

I agree the keyboard is much faster. Try Alt-DownArrow. Then use the
DownArrow key to make your selection. Press Enter.
 
Thanks for the tip
it worked just fine
Ziad

Earl Kiosterud said:
Ziad,

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