You could use data|Validation

Debra Dalgleish has some notes at:
http://www.contextures.com/xlDataVal01.html

TJAC wrote:

In Excel 2002 I'm trying to create a drop down menu in one column. For each
cell in this column, it should be a drop down menu with a menu of about 7
different choices. I can't find the steps on how to create this. Would I
have to create a drop down object in each cell? If anyone can give me a good
site with steps on how to do this or tell me through this posting, I would
really appreciate it!

Thanks,

--

Dave Peterson