Adding drop down menus to a spreadsheet
 

How do I add drop down menus at the top of each column that will both store
and allow for easy retrieval of any entries in the cells beneath?

You can use an AutoFilter (DataFilterAutoFilter). There are
instructions in Excel's Help files, and he

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

angiejoe wrote:
How do I add drop down menus at the top of each column that will both store
and allow for easy retrieval of any entries in the cells beneath?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html