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




"TaylorLeigh" wrote in message
...
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