How do I create pull down menus for individual cells?

[jirl]

I would like to create a pull down menu to limit what a cell contains. For
example, for a column for food groups, I would like the user to select from
a list, such as poultry, red meat, fish... I have not found a way to
implement a pull down menu or even if excel allows a pull down menu. Any
ideas?

 

[Bob Umlas]

Select the cells, select Data/Validation, select List, type in your list
just like you did (no quotes):
poultry, red meat, fish
then click the error Alert tab and put in whatever error message you want.
That's it.

 

[Franz Verga]

I would like to create a pull down menu to limit what a cell
contains. For example, for a column for food groups, I would like
the user to select from a list, such as poultry, red meat, fish... I
have not found a way to implement a pull down menu or even if excel
allows a pull down menu. Any ideas?

Try with Data Validation (menu Data, Data Validation).

You can see the basics here:

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


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

 

[Toppers]

Look at Data Validation

See here for a comprehensive introduction

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

HTH

 

[Mike Monahan]

Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

 

[RagDyeR]

You would have to incorporate "Conditional Formatting" into the drop down
cell as well as the data validation.

Pre XL07 you're allowed 3 conditions (colors) plus the original default
color.

There are alternative approaches to attaining more colors here:

http://www.xldynamic.com/source/xld.CFPlus.Download.html

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Any suggestions for customizing the font (bold desired) and fill color of
individual items on the list? I did not find an answer at contextures.

 

[Mike Monahan]

Conditional Formatting did the trick, and I saved the extended conditional
formatter for a rainy day, thanks for the helpful and prompt solution to my
problem!

 

[RagDyeR]

You're welcome, and appreciate the feed-back.