Auto Filter NON Blanks Cells
 

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?

Auto Filter NON Blanks Cells
 

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...

"indygra" wrote:

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?