How do I repeat rows that are not connected?

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

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

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

[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


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> 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