View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default How do I create pull down menus for individual cells?

Look at Data Validation

See here for a comprehensive introduction

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

HTH

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