You can create a dropdown list by using data validation. There are
instructions in Excel's Help, and he

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

Jon wrote:
How can I make a single cell have a non changing text with a drop down box


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