Auto Filter - how to collapse "non-blank" cells in a column?
 

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?

Auto Filter - how to collapse "non-blank" cells in a column?
 

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?

Auto Filter - how to collapse "non-blank" cells in a column?
 

Got her "squared away" but select all and deselect blanks

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
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?