Rows to repeat on each page

[jpreman]

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

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

[Marcelo]

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
>
>

[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

[jpreman]

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
> >
> >

[Marcelo]

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
> > >
> > >

[jpreman]

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
> > > >
> > > >