Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals for printed sheet?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals for printed sheet?
On Jan 7, 8:04*am, Minx wrote:
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals for printed sheet?
On Jan 7, 8:04*am, Minx wrote:
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals for printed sheet?
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printed multiple pages per sheet | Excel Discussion (Misc queries) | |||
Printed sheet shows text not seen on monitor screen | Excel Discussion (Misc queries) | |||
protect a sheet from being printed? | Excel Discussion (Misc queries) | |||
code for showing a sheet has been printed | Excel Worksheet Functions | |||
Command Button Moves when sheet printed | Excel Discussion (Misc queries) |