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

  • Thread starter Thread starter marla
  • Start date Start date
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?
 

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

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

Back
Top