Force a filter beyond blank rows

D

duketter

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
filter result- total row numbers varies 1
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Insert Rows Below 6
Filters will not include cells beyond the first blank? 2
macro to copy Vlookup formula to some cells with a filter on 0
data spans multiple rows within each cell is collapsed when FILTER is used 0
questions on advanced filter 4

Top