HELP! Repeat lines at bottem of multiple pages

M

Mark

I have created an Excel table with approximately 2500
lines. I have used the Subtotal Function to place page
breaks where I needed them. I have used the Page Setup--
Rows to repeat at top function to format the top of the
Click to expand...
table for printing. I have approximately 10 rows I would
like to repeat right before every page break (the end of
each printed page). The rows have shading and etc, so a
footer will not work. Can anyone please help me
accomplish this without having to copy and paste
repeatly? I am almost certain this can be done.

Thank you in advance for any guidance.
 
T

Tom Ogilvy

It can't be done with any builtin capability of Excel.

There is no rows to repeat at the bottom.
 
D

Dave Peterson

Print them separately and then print the real data a second time. (Adjust the
margins both times).

Maybe even copy the "footer" into Word and print a bunch of forms, then send
those sheets through the printer once again for the real data.

(excel doesn't support "rows to repeat at bottom".)
 
Top