| 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? |
| 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) | |||
Threaded Mode
