ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trying to keep totals at bottom of each page (https://www.excelbanter.com/excel-discussion-misc-queries/104124-trying-keep-totals-bottom-each-page.html)

ffzeus

Trying to keep totals at bottom of each page
 
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

SimonCC

Trying to keep totals at bottom of each page
 
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


"ffzeus" wrote:

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



All times are GMT +1. The time now is 04:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com