Re: Print titles across multiple sheets of a workbook

You cannot do this.

Pagesetup.printtitlerows is sheet-only.

You would have to copy the three rows to each sheet before printing all
sheets.

Each sheet must then be setup to print those title rows either manually
sheet by sheet or by using VBA since you cannot simply group the sheets and
set up rows to repeat at top.


Gord Dibben MS Excel MVP



On Sun, 25 Oct 2009 00:11:10 -0700 (PDT), Subodh <>
wrote:

>I want to repeat the same text in the titles across multiple sheets
>of a workbook. I want to print titles by repeating the same text
>on the top of all sheets of the workbook. ie. i need to repeat the
>Rows 1:3 of Sheet 1
>on all pages printed of sheet1 as well as other sheets in the
>workbook.
>Any help would be appreciated.
>Thanks in advance.

Hi Subodh,

You can do Same as u like, Go Page Setup>Customise>Set name Of Repot , but
befor you silect all work sheet Like Ctrl+A all Requre Sheet then page Setup
..

"Gord Dibben" wrote:

> You cannot do this.
>
> Pagesetup.printtitlerows is sheet-only.
>
> You would have to copy the three rows to each sheet before printing all
> sheets.
>
> Each sheet must then be setup to print those title rows either manually
> sheet by sheet or by using VBA since you cannot simply group the sheets and
> set up rows to repeat at top.
>
>
> Gord Dibben MS Excel MVP
>
>
>
> On Sun, 25 Oct 2009 00:11:10 -0700 (PDT), Subodh <>
> wrote:
>
> >I want to repeat the same text in the titles across multiple sheets
> >of a workbook. I want to print titles by repeating the same text
> >on the top of all sheets of the workbook. ie. i need to repeat the
> >Rows 1:3 of Sheet 1
> >on all pages printed of sheet1 as well as other sheets in the
> >workbook.
> >Any help would be appreciated.
> >Thanks in advance.
>
> .
>