| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limit filter options in Auto Filter
I'm using Excel 2000. I insterted an "AutoFilter" in one of my columns that
contains dates. When I click on the arrow, I would like to only see the choices (ALL), (BLANKS) and (NONBLANKS). I don't want to have to scroll thru the long list of every date that has been entered in that column. Is it possible to limit the filter choices that appear on this pull-down arrow? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Limit filter options in Auto Filter
I don't think you'll be able to change this behavior.
But you could use another column with a formula in it that returns just what you want: =if(a2="","","Used") copy down and filter by this helper column. lista72 wrote: I'm using Excel 2000. I insterted an "AutoFilter" in one of my columns that contains dates. When I click on the arrow, I would like to only see the choices (ALL), (BLANKS) and (NONBLANKS). I don't want to have to scroll thru the long list of every date that has been entered in that column. Is it possible to limit the filter choices that appear on this pull-down arrow? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
| Range limit for auto filter function | Excel Discussion (Misc queries) | |||
| Limit of records when using auto filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| Auto Filter Limit Question | Excel Discussion (Misc queries) | |||
Hybrid Mode
