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

If you want to add rows after the subtotal row, and have all these
summary rows remain visible, add a blank row between the table and the
summary rows.

confused wrote:
Hi,

I have a spreadsheet created by someone else. Autofilter is on all columns,
and there is a row at the bottom called TOTAL which has SUBTOTAL values in
it. When I filter, the TOTAL row is always displayed, which is what I want,
but I cant really understand why it is always displayed.
I actually want to add a second row which will always be displayed, but
beacuse I dont understand how it works, i'm not sure how to do this.

any ideas would be helpful

thanks!



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