| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
nonblank filters in excel 2007
how do i find nonblank filters in excel when working with spreadsheets
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
nonblank filters in excel 2007
"robert mills" wrote:
how do i find nonblank filters in excel when working with spreadsheets Just sparing a thought here, as you haven't received any response yet (not sure why, though <g). ok, I don't have/know the latest xl2007, but would it be any different from say, xl2003, where the option to choose: (NonBlanks) is available in the autofilter dropdown (via Data Filter Autofilter)? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
nonblank filters in excel 2007
Hi Robert
When you select the whole data column and there are blanks you see "Blanks" in the filter list when you click on the arrow in the header -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "robert mills" wrote in message ... how do i find nonblank filters in excel when working with spreadsheets |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count nonblank text cells in Excel | Excel Discussion (Misc queries) | |||
| Data filters in Excel 2007 not working for one file | Excel Worksheet Functions | |||
| Excel 2007 OLAP Pivot table Row Filters | Excel Discussion (Misc queries) | |||
| Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) | |||
| Excel cannot shift nonblank cells | Excel Discussion (Misc queries) | |||
Hybrid Mode
