View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
skelly1969 skelly1969 is offline
external usenet poster
 
Posts: 4
Default Filter not showing blanks option

Sorry, what do you mean? I don't see any responses to my other post, aside
from my own where I provided more info. I've never used this forum before --
are there responses that I'm not seeing?

"Dave Peterson" wrote:

See your other post.

skelly1969 wrote:

One more thing.
I just undid the auto filter. Then I highlighted the date column and
filtered just that column. This time the Blanks and Nonblanks options show
up.
Then if I auto-filter all columns, they stop showing up again.
I want to be able to filter in all the columns, not just the date column.

"skelly1969" wrote:

I have a spreadsheet that have set on autofilter.
I know that if there are no blanks in a column, "Blanks" and "Nonblanks"
will not appear in the drop-down as an option.
However, in this spreadsheet, I have a date column that DOES have blanks,
and the drop-down does not have an option to filter by blanks.
It used to work. I don't know what changed.
I even tried removing the auto filter and resetting it, and it still doesn't
work.
Any ideas?


--

Dave Peterson