View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Mike Monahan Mike Monahan is offline
external usenet poster
 
Posts: 3
Default How do I create pull down menus for individual cells?

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.

"Franz Verga" wrote:

jirl wrote:
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 he

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


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy