Rows to repeat on each page

[Guest]

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

 

[Mr.Cools]

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

 

[Guest]

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:

 

[oldchippy]

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

 

[Guest]

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.

 

[Guest]

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:

 

[Guest]

Thanks a lot Marcelo,

Excellent idea and it works fine.