Autofilter problem

[U_Shrestha]

Hello all,

I have a very large table where I am using autofilter. Whenever I filter any column, the last rows always shows. Is there any automatic way to stop this from appearing. The method I am using to solve this is remove autofilter, highlight the table plus one extra and use autofilter. Can someone show me a better way? Thanks.

[stanleydgrom]

U_Shrestha,

It sounds line there is a blank row of data in your table.

If you can find the blank row of data, then delete that row.


Have a great day,
Stan

[U_Shrestha]

Hello Stan,

There is no blank row, I checked. Thanks.