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?

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?