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