Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to print a row on the bottom of every page
Is there an easy way to print a row or rows at the bottom of every page on a
worksheet? For example i have a worksheet with about 100 rows of info i have to total at the bottom. Well 100 rows won't fit on just one page, but i would like the total to be at the bottom of page 1 and 2. so what I would like to do is have the totals on the last row and then have it print on all the pages. any ideas? |
#2
|
|||
|
|||
It is not provided for in Excel. I kind of think a total would be
confusing if were the same on each page, or do you mean a page subtotal. In any case it is not provided for in Excel and would not be easy to incorporate. It would probably interfere with the normal operation of the worksheet, unless you created a copy of the sheet strictly for reporting purposes. Including a running balance like in your checkbook is not a problem, but doubt that it fits in with your needs. Is this for yourself or something like an insurance policy report. The easiest way would be to put something into the top rows in the repeat area that assigns the value from the total cell. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Punx" wrote in message ... Is there an easy way to print a row or rows at the bottom of every page on a worksheet? For example i have a worksheet with about 100 rows of info i have to total at the bottom. Well 100 rows won't fit on just one page, but i would like the total to be at the bottom of page 1 and 2. so what I would like to do is have the totals on the last row and then have it print on all the pages. any ideas? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Non-Breaking Space + Print Issue | Charts and Charting in Excel | |||
Page breaks don't show on screen and don't print separately. It i. | Excel Discussion (Misc queries) | |||
print titles won't appear on some pages | Excel Discussion (Misc queries) | |||
Same Cell Header For Every Page | Excel Discussion (Misc queries) |