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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatted cell column in drop down list 1
Create a drop-down list from a range of cells 2
drop down lists 1
Excel Excel: How do I put a formula in a drop down list 11
Drop Down Lists 2007 10
Creating a Drop Down List with Step by Step Instructions for 2007 2
Drop Down List 2
How do I make coloured drop down lists in Excel? 3

Back
Top