Trying to keep totals at bottom of each page

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

Guest

Hi,

Is there a way to keep a row or two always visible at the bottom of a page.
I want to show running totals and percentages for columns and have new data
always insert above the last lines which show this information.

Thank you.

Curtis
 
Try selecting the row with the total. Then go to Window | Split to have two
sections in your sheet. You can adjust the split sections freely with the
split bar. Scrolling is independent for the two sections. So you can keep
the bottom section in place while you scroll the top section.

-Simon
 
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

keep total formulas / rows when apply filter 1
Formatting Totals at Bottom of Page 7
moving totals 2
Report to start Print at Bottom of a page instead of top of page 0
How do I insert a Sub total at every page break? 1
Total Column in Pivot Table 5
Running total at bottom of column? 3
how do I get a cummulative total in excel 1

Back
Top