Blanks non blanks in filter

T

TaylorLeigh

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

bj

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
 
P

Peo Sjoblom

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

Top