How do I insert a drop down list in a cell using

P

Phil

I have a chart. It has six headings under one of them I would like a drop
down to choose Yes or No. I need step-by-step instruction. Thanks,
 
D

Debra Dalgleish

You can use Data Validation to create a dropdown list in a cell. There
are instructions here:

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

For a short list of options (Yes, No), you can use a delimited list,
instead of a list on the worksheet, as described in step 4 of the
instructions.
 
Top