How do I have a list of possible answers auto put into a cell?

[smags]

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]

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 here:

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