| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Filter NON Blanks Cells
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Auto Filter NON Blanks Cells
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... "indygra" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Filter - Add visible cells | Excel Worksheet Functions | |||
| Auto Filter and Merged Cells | Excel Worksheet Functions | |||
| copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
| How to Sum-If when the cells to sum are Auto-filter visable cells? | Excel Discussion (Misc queries) | |||
| How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
Hybrid Mode
