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

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

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

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

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

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

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