Can I lock a row so that it's always the last row on the page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hidden rows problem 7
Can I repeat rows at the top, except the last page? 3
locking multiple rows in excel 03 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
using the =page! feature to transpose a row to column 0
Selecting rows. 3
Printing a Different Row Heading Mid-way through a Spreadsheet 1
Printing non-contiguous rows at the top 1

Back
Top