Print repeating rows with multiple manual page breaks

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 12 Apr 2004 01:43 GMT

My sheet has five tables, each one with a different table headers.
I've inserted a page break at the bottom of each table so each new
table starts on a new page.

The problem is, I effectively need the "Print titles: Rows to repeat
at top" option of the page setup to repeat the rows corresponding to
each table...not the same "hard-coded" rows allowed by this option.

Any suggestions? (Also, the tables' lengths are dynamic)

Reply to this Message

David McRitchie - 12 Apr 2004 13:06 GMT

Hi John,
Use different worksheets.
When you copy or print the sheets, group them first,
don't forget to ungroup your sheets when finished or risk
loss of your data as any change made to the visible sheet
will be made to all sheets in the group.

To group sheets use the Ctrl key to select additional sheets,
or right click on the sheet tab for choice to select all sheets.
To ungroup sheets the safest is to use the right click on the
sheet tab and choose "ungroup sheets". The faster way
is to pick a single sheet tab preferably outside the grouped
sheets.
---
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

> My sheet has five tables, each one with a different table headers.
> I've inserted a page break at the bottom of each table so each new
[quoted text clipped - 5 lines]
>
> Any suggestions? (Also, the tables' lengths are dynamic)

Reply to this Message

Rate this thread: