Rows to repeat on each page
Thanks for reading this post.
Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks |
Rows to repeat on each page
If you want to repeat them in print Go to
File-Page setup-Sheet-Rows to repeat at top and select rows 2,4,5 jpreman wrote: Thanks for reading this post. Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks |
Rows to repeat on each page
Hi,
could you be more clear with exactly you are looking for? -- hth regards from Brazil May the force be with you Marcelo ******************* "jpreman" escreveu: Thanks for reading this post. Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks |
Rows to repeat on each page
jpreman Wrote: Thanks for reading this post. Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks Hi jpreman, If you click your first page tab, then while holding the ctrl key,click the other tabs, this forms a group. so what ever you type on the first page in rows 1, 3 or 6 will also appear on the other sheets. To unselect the group, right click unselect sheets oldchippy :) -- oldchippy ------------------------------------------------------------------------ oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907 View this thread: http://www.excelforum.com/showthread...hreadid=572139 |
Rows to repeat on each page
Thanks for your responses.
I would like to view all the rows on screen i.e including rows 2, 4 & 5. However, on print I wish to have only rows 1, 3 & 6 to repeat on each page of a single worksheet. Hope I am clearer now. "Marcelo" wrote: Hi, could you be more clear with exactly you are looking for? -- hth regards from Brazil May the force be with you Marcelo ******************* "jpreman" escreveu: Thanks for reading this post. Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks |
Rows to repeat on each page
hi,
one way to do it is using a macro ************************************************** *** Sub hide_rows_and_print() Rows("2:2").Select Selection.EntireRow.Hidden = True Rows("4:5").Select Selection.EntireRow.Hidden = True ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Rows("1:1000").Select Selection.EntireRow.Hidden = False Range("A1").Select End Sub ************************************************** *** hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "jpreman" escreveu: Thanks for your responses. I would like to view all the rows on screen i.e including rows 2, 4 & 5. However, on print I wish to have only rows 1, 3 & 6 to repeat on each page of a single worksheet. Hope I am clearer now. "Marcelo" wrote: Hi, could you be more clear with exactly you are looking for? -- hth regards from Brazil May the force be with you Marcelo ******************* "jpreman" escreveu: Thanks for reading this post. Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks |
Rows to repeat on each page
Thanks a lot Marcelo,
Excellent idea and it works fine. "Marcelo" wrote: hi, one way to do it is using a macro ************************************************** *** Sub hide_rows_and_print() Rows("2:2").Select Selection.EntireRow.Hidden = True Rows("4:5").Select Selection.EntireRow.Hidden = True ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Rows("1:1000").Select Selection.EntireRow.Hidden = False Range("A1").Select End Sub ************************************************** *** hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "jpreman" escreveu: Thanks for your responses. I would like to view all the rows on screen i.e including rows 2, 4 & 5. However, on print I wish to have only rows 1, 3 & 6 to repeat on each page of a single worksheet. Hope I am clearer now. "Marcelo" wrote: Hi, could you be more clear with exactly you are looking for? -- hth regards from Brazil May the force be with you Marcelo ******************* "jpreman" escreveu: Thanks for reading this post. Is there any way I could repeat, for instance rows 1, 3 & 6 of a worksheet, on each page? (i.e. rows 2, 4 & 5 should not repeat on each page) Thanks |
All times are GMT +1. The time now is 11:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com