View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Blanks non blanks in filter

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

"TaylorLeigh" wrote:

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