Drop Down List

[Matt]

How can I create a drop down list in a field? For example, I would like to be
able to click on Field A1 and a drop down list pop up asking me what
preselected information I would like to select, like (name, date, time, etc)?

 

[Gord Dibben]

Data>Validation>List.

For more information and instructions on how to set this up, see Debra's site.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

 

[Max]

How can I create a drop down list in a field? For example, I would like to be
able to click on Field A1 and a drop down list pop up asking me what
preselected information I would like to select, like (name, date, time, etc)?

Try Debra's vintage, starting at:
http://www.contextures.com/xlDataVal01.html