I need to be able to have a "totals" row at the bottom of each page. I also
have to hide unused rows in the middle (or "body" of my form). Is it possible
to "lock" the last row so that it's independent of the rows I hide just like
you can have the top rows repeat at the top of every page.

If you move your totals to row 1, it make your life much, much easier.

And if you freeze panes so that row 1 (and the header rows) are always visible,
that can help the user.

I like to use the =subtotal() function and apply data|filter|autofilter so that
the totals only total what's visible.

sach wrote:

I need to be able to have a "totals" row at the bottom of each page. I also
have to hide unused rows in the middle (or "body" of my form). Is it possible
to "lock" the last row so that it's independent of the rows I hide just like
you can have the top rows repeat at the top of every page.

--

Dave Peterson