How do I repeat rows that are not connected?

M

mozierosie

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.
 
D

Dave Peterson

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.
 
J

Jasy

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
 
Top