New Rows And Filtering

[Ark68]

I have a database that I filter. Sometimes, I will add additional rows of data to the end of the filtered list of data.

However, when I apply another filter, the rows that had been added aren't included in the filter. Despite any filter I do, the new rows are always displayed. The filtered rows show with the blue row numbers, but at the end are the added rows with black row numbers.

What do I need to do to ensure new rows are included in future filters. Right now, I have to turn the filter off, and reapply it. This is a pain.

 

[taigovinda]

Try selecting the entire columns, not just the top row, when you apply your autofilter. Also it helps if there are not blank rows within your data.

 

[Ark68]

I'm applying the filter to Row 4 which is my header row. Will this not work.
I will look for blank rows ...

 

[taigovinda]

In that case, try selecting from row 4 all the way down to the bottom of the sheet. I'm not sure it will work, but I've definitely noticed it works better (in terms of not dropping off bottom rows) than just selecting row4.