Auto Filter NON Blanks Cells

I

indygra

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

Sheeloo

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

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

Dealing with the error: unable to filter on excel hc home school 0
Auto Filter - how to collapse "non-blank" cells in a column? 2
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 3
Excel 2002: Can I not overwriting non blank destination cells ? 0
How to count non blank cells with a condition? 1
Count from Blank & Non-Blank Cells 2
filter non-blanks before closing 1
Filtered drop down list 2

Top