View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default How do I create pull down menus for individual cells?

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.

"jirl" wrote in message
...
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?