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

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

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

Hi,

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

Regards!
Jean-Guy

"Richard Snyder" wrote:

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

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

Check Data|Validation (probably a list)
--
HTH...

Jim Thomlinson


"Richard Snyder" wrote:

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

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

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

On Nov 16, 6:42 pm, Richard Snyder <Richard
wrote:
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

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

See this:

http://youtube.com/watch?v=t2OsWJijrOM

--
Biff
Microsoft Excel MVP


"Richard Snyder" <Richard wrote in message
...
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