Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
single worksheet, multiple pages - subtotal
Hi,
Newbie here using Excel 2003. I hope my questions make sense. I have a worksheet with lots of columns & rows, printing on multiple pages. -- How can I insert a subtotal at the bottom of each running page? -- Is there a way to make the subtotal auto-adjust? Let's say I add 10 rows to pg. 1, which now push the 10 bottom rows to page 2. Can the subtotal remain as the last line on page 1 and recalculate accordingly? -- On the last page, last row, how do I create a grand total, adding all subtotals together? Thanks in advance for your time and expertise! Regards, Shirley |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing multiple pages (2x2) double sided with single sided print | Excel Discussion (Misc queries) | |||
Printing single pages from multiple worksheets in a single print job | Excel Discussion (Misc queries) | |||
Automatically separating worksheet into multiple pages | Excel Discussion (Misc queries) | |||
Converting multiple worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
Single worksheet, multiple pages? | Excel Discussion (Misc queries) |