| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to auto "copy & paste" (or filter) from a Master spreadsheet? | Excel Worksheet Functions | |||
| How do I filter "Blank" cells in Pivot Table | Excel Discussion (Misc queries) | |||
| Change the Auto-filter that is "on" to a RED arrow, can't see blu | Excel Worksheet Functions | |||
| Removing "Blank Cells" from a column | Excel Worksheet Functions | |||
| Q: Auto filter "selected" color | Excel Discussion (Misc queries) | |||
Linear Mode
