I'm not sure what you mean, but you can use data validation to create
drop down lists in cells. There are instructions in Excel's Help, and he

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

smags wrote:
If I have a 'legend' of answers and I want the input cells to reference this
legend and put one of the possible answers into the input cell, how do I
accomplish this?


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