Auto Filter NON Blanks Cells

I

indygra

Older version of excel could be Autofiltered to non blank cells, which would
hide all the cells in a column that were blank. Excel 2007 does not have
this function, how can I add the NON Blank in the drop down under the
Autofilter arrow?
 
S

Sheeloo

In Excel 2007 list of values in Filter dropdown have checkboxes against them.

To see only the non-blank values clear the check box against BLANKS...
 
Top