| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Force a filter beyond blank rows
Excel 2007 - I am applying a filter to a table, however the filter entry
stops on when there is a blank row in the file (example, filter works from rows 2-40) but then if row 41is blank the filter stops and won't filter rows beyond 41. I have 500,000+ rows and there are many blank rows every so often so how can I force the filter to go down the entire column of data without stopping on the first blank row? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Force a filter beyond blank rows
Hio,
highlight the column first and then apply filters "duketter" wrote: Excel 2007 - I am applying a filter to a table, however the filter entry stops on when there is a blank row in the file (example, filter works from rows 2-40) but then if row 41is blank the filter stops and won't filter rows beyond 41. I have 500,000+ rows and there are many blank rows every so often so how can I force the filter to go down the entire column of data without stopping on the first blank row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter for blank fields in multiple rows | Excel Discussion (Misc queries) | |||
| Custom Filter loses blank rows | Excel Worksheet Functions | |||
| Use Advanced Filter to Detect non blank rows | Excel Discussion (Misc queries) | |||
| Force a blank cell to zero | Excel Discussion (Misc queries) | |||
| Auto Filter out text or blank rows | Excel Discussion (Misc queries) | |||
Linear Mode
