How to total on each page

nedoo2002us

New Member
Joined
Aug 1, 2011
Messages
5
Dear Sir,
Please tell me how total on each page at its bottom be printed if work sheet holds 100 pages..
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Not exactly sure what you are asking but maybe Subtotals would work for you. If you go to Data > Subtotals you can choose which data to total and use the option to insert a page break after each subtotal.
 
Upvote 0
Thank you for replying my question; I am sorry to fail as to elobrate my problem more properly.
I hold a worksheet, it contains 100 pages, I need to have its total from row # 1 to
last row# 35(in a particular column) on each subsequent page, until the last page,
on last page it also give grand total (from row#1 to last row). The result may be viewed
as well as to have printed on hard copy.

(2) In the above situation if I need total on each page, it should be not as sub-total
but it should be progressive total until the last page.
 
Upvote 0
I think you have no response, because what you are asking (as I understand it) would be extremely difficult and therefore not something somebody is likely to want to try to tackle in a free public forum like this.

The problem is that Excel does not have a facilty for putting something at the bottom of pages (apart from footers of course). Additionally, the bottom of a page is generally not a 'fixed' thing. It depends on your printer & printer driver, row heights, paper size etc. So to do this you would have to, at the time of printing, try to determine where the bottom of each page was, add in a new row (making sure that did not cause an overflow to the following page), work out where the previous page finished, add totals for the current page, make sure that these totals were removed at some stage or at least that they were not adding in to your final grand total etc.

If you do happen to have hard-coded page breaks (that still leave room for a page total row without causing a spill over to the next page) then there may be a bit more of a chance. However, if that were the case you could probably just have subtotal formulas permanently at the bottom of each page. But if a user add/deletes rows changes font size, row height, margins etc you are likely to find that your print layout has gone astray.
 
Last edited:
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top