HELP! Repeat lines at bottem of multiple pages

  • Thread starter Thread starter Mark
  • Start date Start date
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.
 
It can't be done with any builtin capability of Excel.

There is no rows to repeat at the bottom.
 
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".)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repeat Rows at Top - Except Final Page 2
repeat rows at top of page 4
Footer 1
Repeating Rows - Exception 1
Printing very large spreadsheet 1
Change print titles (rows to repeat at top) on subsequent pages 2
Repeat Pivot Row on when printing 1
Rows to Repeat on Top of everypage EXCEPT for two pages 1

Back
Top