Drop Down List Selections

[Spencer]

I have created a spreadsheet with a few drop down list via data validation. I would like to be able to navigate through this spreadsheet with only using the keyboard and not a mouse. I can tab over to the cell with that contains the drop down list, but I can't seem to find a way to activate the drop down function as one normally would by selecting the triangle with their mouse. Is there a way to display the entire drop down list, navigate to an individual item in the list and select it using only the keyboard?

Thanks, Spence

[Paul]

Hi Spencer,

You can press ALT+DOWNARROW to expand the list, then use the down/up arrow keys to move down/up the list and press Enter or the spacebar to select the currently highlited option.

[Spencer]

pjoaquin, thank you for the quick and helpful reply. That is exactly the answer I was looking for. The more I work with Excel, the more I want to do everything with just the keyboard.

Thanks, Spence

[Paul]

You're very welcome, Spence. Glad I could help.