Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Title Cut Off if Rows to Repeat & Columns to Repeat are Both Selec | Excel Discussion (Misc queries) | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Excel should allow me to repeat bottom rows on every page. | Excel Worksheet Functions | |||
Rows to repeat at the bottom | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |