How do I repeat rows that are not connected?
 

My spreadsheet is already repeating the first 8 rows on each page. I would
also like it to repeat the last four lines on each page, but don't know how
to do so. I'm currently using a text box that's repeated on each page, but
it's time consuming to update each text box when the data changes. I've
tried putting the info in as a footer but it get's chopped into the left,
center & right sections vs. being one continuous line of text.

How do I repeat rows that are not connected?
 

Excel doesn't support a "rows to repeat at bottom".

It sounds like the you have a workaround that may not be pretty, but works.

mozierosie wrote:

My spreadsheet is already repeating the first 8 rows on each page. I would
also like it to repeat the last four lines on each page, but don't know how
to do so. I'm currently using a text box that's repeated on each page, but
it's time consuming to update each text box when the data changes. I've
tried putting the info in as a footer but it get's chopped into the left,
center & right sections vs. being one continuous line of text.

--

Dave Peterson

How do I repeat rows that are not connected?
 

Dave
Try to link your text box with a cell. When the cell changes, the data will
be updated automatically.

To link text box, do the following.
Select your text box, type an equal sign (=) at the formula bar, then click
the cell that you want

to link to. Press Enter to create the linked text box.

Jasy


"Dave Peterson" wrote in message
...
Excel doesn't support a "rows to repeat at bottom".

It sounds like the you have a workaround that may not be pretty, but
works.

mozierosie wrote:

My spreadsheet is already repeating the first 8 rows on each page. I
would
also like it to repeat the last four lines on each page, but don't know
how
to do so. I'm currently using a text box that's repeated on each page,
but
it's time consuming to update each text box when the data changes. I've
tried putting the info in as a footer but it get's chopped into the left,
center & right sections vs. being one continuous line of text.

--

Dave Peterson