View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
pinmaster pinmaster is offline
external usenet poster
 
Posts: 347
Default 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