How do I create a drop down box that is not a filter in Excel?

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

Guest

I have an Excel work sheet that has a Drop down box with Active and
Non-Active and I want it to have Yes and No. It is not a form because there
is no coding attached and it is not a filter. Please Help
 
Hi,

Select the cell then go to Data/Validation, you can make the changes there!

Regards!
Jean-Guy
 
It may well be from Data Validation. Select the cell and click on Data
| Validation and in the Settings tab you may well have List selected -
you can type yes and no separated by a comma as your acceptable
values, or point to a range that contains the values that you allow.

Hope this helps.

Pete
 

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

Filtered drop down list 2
How to delete a drop down box in Excel 2007 1
Auto filter drop down box 1
How do I transfer a filter drop down box to another cell? 2
Viewing drop down box for a filter 2
filter not working 2
Why do my drop down filters no longer work? 3
how to delete drop down boxes 2

Back
Top