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

M

marla

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?
 
D

Don Guillett

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count from Blank & Non-Blank Cells 2
Auto Filter NON Blanks Cells 1
How can I auto refresh a column that has an auto filter in place 1
filter non-blanks before closing 1
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Filter (blanks) with two or more unique values not working 1
advanced filter for blanks 1
Deleting blank cells globally 8

Top