totals

[vac]

Can anyone help me please
Hi everybody,
I have a worksheet where the amount of rows used alters, sometimes may only be 10, or sometimes maybee 100 or so, also the row hight can change because i wrap the text so as to showw all the text in the cells, this is my quotation sheet.
What I want to do is when I print the sheet, I want at the bottom of a colum, the subtotal for that colum on each sheet, then on the last printed sheet a total.
For example, I have a worksheet containing 300 rows.This would take up 10 pages when I print it. On the bottom corner of each printed page I would like a sub total of say colum E, and on the last page a grand total.
I hope this can be done, Many thanks, vac

 

[Mark W.]

And you can't use the "Page break between groups" Subtotal option, and add a page break before the Grand Total?

 

[vac]

Mark W, could you please explain a little more, many Thanks

 

[Mark W.]

If you're not already using the Data | Subtotal... menu command see the Excel Help Topic for "Overview of subtotals in lists".