Blanks non blanks in filter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I turned on the filter on an excel spreadsheet. When I look at the drop down
list from any given column I do not see the blanks - non blanks selection. I
have done this on other spreadsheets and those two options are available.
Why is this?
 
verify that you actually have blanks They may look blank but not actually be
"Spaces etc". if there are no blanks in the selection the blanks-non blanks
will not show
 
Make sure you select the whole range you want to include in the filter or
else Excel might cut it off where the first blank starts.


--


Regards,


Peo Sjoblom
 

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

Filter not showing blanks option 6
Count from Blank & Non-Blank Cells 2
Auto Filter - how to collapse "non-blank" cells in a column? 2
Auto Filter NON Blanks Cells 1
filter non-blanks before closing 1
Filtered drop down list 2
advanced filter for blanks 1
Force a filter beyond blank rows 1

Back
Top