Limit filter options in Auto Filter

L

lista72

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?
 
D

Dave Peterson

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.
 
Top