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

R

Richard Snyder

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
 
P

pinmaster

Hi,

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

Regards!
Jean-Guy
 
P

Pete_UK

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
 
Top