How to stop the last record always appearing when I Autofilter

T

TAG

I have a table of approx 1200 records and when I use Autofilter to select
specifc records the last record in my table always appears.
 
D

Dave Peterson

Next time you apply a filter to that range, notice that the dropdown arrow has
changed color to blue for that column.

And the row indicators for the range that's filtered are blue.

But that last row that shows up, but doesn't match the filter as a row indicator
of black/normal.

This means that that row is not part of the filter range.

So remove the data|Filter|autofilter and select all the range and re-apply
data|filter|autofilter.
 
Top