single worksheet, multiple pages - subtotal

[Shirley]

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