If you have a Subtotal formula in the last row of the table, that
row is excluded from the filter, and always remains visible.

Try adding something temporarily in a cell in the next row, such as "END"
Then, apply the filter again, and see if the original last row is
included in the filtered range.

Once the filter is working correctly, you should be able to clear the
cell with the temporary text.


Ben Wunderin wrote:
I am using autofilter in Excel 2003. When I filter on any item in the list,
autofilter gives a display that not only contains the list items filtered but
also the last line on the worksheet. It does not matter what item I filter
on, the last line always appears as well. Can anyone help me know what I am
doing wrong?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com