How do I create a drop down list in a cell in Excel?

[Guest]

Hi,

I'm trying to format my Excel worksheet and I want to create a dropdown list
for users to select an option.

Example: In one field called "shoes", there are many different types. I
want the data entry person to be able to indicate that Miss Jane has chosen
"blue suede" shoes.

Thank you for your assistance.

 

[Max]

One quick play ..

Select the target cell (or col)
Click Data > Validation
Under Allow: choose List
Put in "Source:" box: blue suede, black suede, red suede
Click OK

Do check out also Debra Dalgleish's
nice coverage of Data validation at:
http://www.contextures.com/xlDataVal01.html

 

[Guest]

Sounds like you may want to explore Conditional Formatting.
Try this site to get you started:
http://www.contextures.com/xlCondFormat01.html

tj

 

[Guest]

Thank you Max. That is great info!

LN

One quick play ..

Select the target cell (or col)
Click Data > Validation
Under Allow: choose List
Put in "Source:" box: blue suede, black suede, red suede
Click OK

Do check out also Debra Dalgleish's
nice coverage of Data validation at:
http://www.contextures.com/xlDataVal01.html

 

[Max]

Pleasure`, Lisa !
Thanks for the feedback ..

 

[Dave Peterson]

I bet you meant Data|Validation--with this link to Debra Dalgleish's site:

http://www.contextures.com/xlDataVal01.html