Filter not showing blanks option

[skelly1969]

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?

 

[skelly1969]

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.

 

[Dave Peterson]

See your other post.

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]

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]

Are you also posting as MitchellWMA?

If you're not, then sorry. (Your question and MitchellWMA's question was so
close (and unusual), that I thought it was from the same person.)

Remove the autofilter.
Select the range (don't let excel guess)
reapply the autofilter.

Filter by any field (use custom not equal to xxxxxx--some unused string).

You'll notice that the row numbers change colors in the autofiltered range.

Is the range what you expected?

====
If you select a cell in a range and let excel guess at the range that should be
filtered, it often (always???) stops the range when it encounters an empty row
or empty column.

 

[skelly1969]

Nope, I'm not posting as MitchellWMA -- I didn't see that post.

This worked -- thanks for your help!

 

[Dave Peterson]

Sorry about my confusion!

Nope, I'm not posting as MitchellWMA -- I didn't see that post.

This worked -- thanks for your help!