How do I repeat rows that are not connected? in Excel Worksheet Functions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              mozierosie 1/6/2006 3:30 PM PST   Question   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.     Was this post helpful to you?         Reply |   Top           Dave Peterson 1/6/2006 4:56 PM PST   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     Was this post helpful to you?         Reply |   Top           Jasy 1/9/2006 1:20 AM PST   Answer   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" <petersod@verizonXSPAM.net> wrote in message news:43BF1146.939CAF02@verizonXSPAM.net... > 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     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies