software

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 amp; right sections vs. being one continuous line of text.

Excel doesn't support a quot;rows to repeat at bottomquot;.

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

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

--

Dave Peterson

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.

Jasyquot;Dave Petersonquot; gt; wrote in message
...
gt; Excel doesn't support a quot;rows to repeat at bottomquot;.
gt;
gt; It sounds like the you have a workaround that may not be pretty, but
gt; works.
gt;
gt; mozierosie wrote:
gt;gt;
gt;gt; My spreadsheet is already repeating the first 8 rows on each page. I
gt;gt; would
gt;gt; also like it to repeat the last four lines on each page, but don't know
gt;gt; how
gt;gt; to do so. I'm currently using a text box that's repeated on each page,
gt;gt; but
gt;gt; it's time consuming to update each text box when the data changes. I've
gt;gt; tried putting the info in as a footer but it get's chopped into the left,
gt;gt; center amp; right sections vs. being one continuous line of text.
gt;
gt; --
gt;
gt; Dave Peterson