You can use Data Validation to create a dropdown list. There are
instructions in Excel's Help, and he

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

Piper wrote:
I have been trying to put together an Excel Sheet giving multiple answers on
a drop down table. Any suggestions would be very much appreciated. Thanks A.


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