ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I display totals on the bottom of a printed page in Excel. (https://www.excelbanter.com/excel-discussion-misc-queries/147881-how-can-i-display-totals-bottom-printed-page-excel.html)

ECC Partner

How can I display totals on the bottom of a printed page in Excel.
 
I have a spreadsheet that prints on multiple pages. I would like the totals
row to print on the bottom of each page. The totals would be for the whole
column not just waht is on the page.

Nick Hodge

How can I display totals on the bottom of a printed page in Excel.
 
This may not help you, but if you use the 'Sub Total' function
(DataSubtotal...) then you can insert a page break between each 'group'

Just a thought that may help, other than that you are going to need to do it
manually

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web:
www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

"ECC Partner" wrote in message
...
I have a spreadsheet that prints on multiple pages. I would like the
totals
row to print on the bottom of each page. The totals would be for the
whole
column not just waht is on the page.




All times are GMT +1. The time now is 08:48 PM.

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