Thread: subtotal pages
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ed ed is offline
external usenet poster
 
Posts: 82
Default subtotal pages

Can't seem to find this anywhe I have a worksheet with 6 long
columns of numbers that when printed may be anywhere from 15 to 25
rows per page due to rows of different heights. I conquered the "top
3 lines printed on every page" but can't figure out this problem. If I
let excel automatically size each page how do I put a subtotal at the
bottom of each page, and grand total at the end of the last page? I
want to imbed the subtotaling formulas so when I have finished
entering numbers and print the worksheet the totals will automaticlaly
be on every page. I prefer the total at the bottom of the page, not
the bottom of each column, which may not have numbers in all the rows.

Thanks mucho.