In addition to the information Arvi provided, there are instructions for
Data Validation in Excel's Help, and he

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

Frosty1 wrote:
I cannot figure out how to create a drop down menu with numbers to use in
individual cells. I also want the ability to use names as well.


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