Subtotals for printed sheet?

M

Minx

Is there a way to give me sheet subtotals at print time?

I have a spreadsheet with rows and rows of calculations. I do not set hard
page breaks because the number of rows varies as the project moves along. Is
there any way that I can get the subtotal of various columns for each page
printed? Kind of like a header, except with summation?
 
J

jlclyde

Is there a way to give me sheet subtotals at print time?

I have a spreadsheet with rows and rows of calculations. I do not set hard
page breaks because the number of rows varies as the project moves along. Is
there any way that I can get the subtotal of various columns for each page
printed? Kind of like a header, except with summation?

What I like to do is use the list feature and then have it auto sum at
the bottom. You can have your A row = to your sums at the bottom. So
you ahve the total at the top and bottom. The more lines you add the
bigger the list gets. To use this you have to highlight the
information that you want included in the list and right click/ create
list. You do have to be careful with this feature though. If you
have multiple people using this workbook and if any of them do not
have Excel 2003 or newer the list feature will stop working and will
ahve to be added back in.
Hope this helps,
Jay
 
J

jlclyde

Is there a way to give me sheet subtotals at print time?

I have a spreadsheet with rows and rows of calculations. I do not set hard
page breaks because the number of rows varies as the project moves along. Is
there any way that I can get the subtotal of various columns for each page
printed? Kind of like a header, except with summation?

I am sorry. I got too excited and thought I had the answer. What I
told you in the first post will not work at all to do what you want.
I am curious to learn if there is a way now.

Sorry,
Jay
 
J

Jim Cone

Excel has no built-in way to accomplish that.
My commercial add-in "Special Print" can do it with a work around.
You can download the free trial and use the Rows to Repeat at Bottom utility.
You will need to enter subtotal formula(s) using R1C1 type references in
the repeating row. The formula(s) must be entered without the equal sign.
You replace the equal sign(s) after the sheet you print from is created.
If you have questions I can provide guidance.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Minx"
wrote in message
Is there a way to give me sheet subtotals at print time?

I have a spreadsheet with rows and rows of calculations. I do not set hard
page breaks because the number of rows varies as the project moves along. Is
there any way that I can get the subtotal of various columns for each page
printed? Kind of like a header, except with summation?
 

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

Top