select the ENTIRE range(not just the header) then deselect all and select
blanks

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"marla" wrote in message
...
In previous versions of Excel, when adding an Auto Filter to a column, a
user
was able to select "non-blanks" from the pull down menu which would cause
all
cells with no values or text within the same column to be hidden. In Excel
2007, the "non-blanks" option has been removed. How does one collapse all
the
non-blank cells within a column using the filter in Excel 2007?