Filter not showing blanks option

  • Thread starter Thread starter skelly1969
  • Start date Start date
S

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?
 
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.
 
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.
Click to expand...
 
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?
 
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.
 
Nope, I'm not posting as MitchellWMA -- I didn't see that post.

This worked -- thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
Limit filter options in Auto Filter 1
Blanks non blanks in filter 2
Filter for "blanks" in multiple columns simultaneously 2
Excel 2003 1
Auto filter drop down box 1
Auto Filter NON Blanks Cells 1
filter not working 2

Back
Top