Using a validation list drop down box with keyboard only

G

Guest

Good afternoon!

I have applied data validation to a cell - the user can pick from a range of
values within a range of cells. Normally, you'd have to click on the drop
down arrow to see the list - is there any way, with the cell selected, to
dispay the drop down list via a keyboard combination, instead?

Thanks in advance

Pete
 
P

Paul B

Pete, Alt & down arrow on your keyboard
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
G

Guest

Paul,

Sooooooooooo simple when you know how!
The question is, do I really WANT to make it easier for my wife to check
where all the household "miscellaneous" money is going..? :)

Thanks VERY much.

Pete
 
P

Paul B

Your Welcome
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Drop down list 2
Data validation list using filtered range 3
Customise drop down list validation 3
Size of drop down in validation list 2
Filtered drop down list 2
drop downs showing down arrow 4
Data Validation List (Drop Down) Not Showing 2

Top