Drop Down List

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 24 Jan 2008 20:23 GMT

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)?

Reply to this Message

Gord Dibben - 24 Jan 2008 22:50 GMT

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

>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)?

Reply to this Message

Max - 24 Jan 2008 22:57 GMT

> 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

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message