| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Get rid of Excel extra left margin filter drop down box | Excel Worksheet Functions | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| Excel Auto Filter will not show all items in the drop down - why? | Excel Discussion (Misc queries) | |||
| how to create a combo box in excel - how to create the drop down . | Excel Discussion (Misc queries) | |||
| Excel - how do I use drop down list to filter data | Excel Worksheet Functions | |||
Linear Mode
