Drop-down List

[Leaf]

Thanks in advance

I want to add a drop-down list in the cell for the choice.
Can anyone help me on how to do it

Thank yo

Leaf

 

[Guest]

Go to Data-> Validation and then you will choose List
(where you will hard code the values in the drop down).

Hope this helps.

 

[Debra Dalgleish]

When you choose Data>Validation, you can type a list of the choices, or
refer to a list on your worksheet.

There are instructions in Excel's Help files, and some on my web site:

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