I want to repeat the same text in the titles across multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want to print titles by repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the required titles to multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.

Do you mean when printing you want to set "rows to repeat at top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.


Gord Dibben MS Excel MVP



On Tue, 22 Sep 2009 09:22:29 -0700 (PDT), Subodh
wrote:

I want to repeat the same text in the titles across multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want to print titles by repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the required titles to multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.

On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:
Do you mean when printing you want to set "rows to repeat at top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP

On Tue, 22 Sep 2009 09:22:29 -0700 (PDT), Subodh
wrote:



I want to repeat the same text in thetitlesacross multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want toprinttitlesby repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the requiredtitlesto multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.- Hide quoted text -

- Show quoted text -

Has any one got VBA code for this

See http://www.codeforexcelandoutlook.co...repeat-at-top/

ActiveSheet.PageSetup.PrintTitleRows = "$1:$1"

would repeat row one at the top of each printed page.

--JP

On Oct 5, 9:12*am, Subodh wrote:
On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:


Do you mean when printing you want to set "rows to repeat at top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP


* *Has any one got VBA code for this

Using VBA code you can set the same print range and rows to repeat at top on
each sheet in grouped sheets.

See this google search result with Dave Peterson and myself posting. The
print area code is from Bob Flanagan.

http://snipurl.com/106kz


Gord


On Mon, 5 Oct 2009 06:12:40 -0700 (PDT), Subodh wrote:

On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:
Do you mean when printing you want to set "rows to repeat at top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP

On Tue, 22 Sep 2009 09:22:29 -0700 (PDT), Subodh
wrote:



I want to repeat the same text in thetitlesacross multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want toprinttitlesby repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the requiredtitlesto multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.- Hide quoted text -

- Show quoted text -

Has any one got VBA code for this

On 5 Oct, 14:18, Gord Dibben <gorddibbATshawDOTca wrote:
Using VBA code you can set the same print range and rows torepeatat top on
each sheet in grouped sheets.

See this google search result with Dave Peterson and myself posting. *The
print area code is from Bob Flanagan.

http://snipurl.com/106kz

Gord



On Mon, 5 Oct 2009 06:12:40 -0700 (PDT), Subodh wrote:
On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:
Do you mean when printing you want to set "rows torepeatat top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP

On Tue, 22 Sep 2009 09:22:29 -0700 (PDT), Subodh
wrote:

I want torepeatthe same text in thetitlesacross multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want toprinttitlesby repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the requiredtitlesto multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.- Hide quoted text -

- Show quoted text -

* Has any one got VBA code for this- Hide quoted text -

- Show quoted text -

This worked but not as i required. This sets the same print range and
rows to repeat at top on
each sheet in grouped sheets. ie. Rows 1:3 in each of each
Sheet1,Sheet2.............. are repeated in their respective pages.
But what i need is to repeat the Rows 1:3 of Sheet 1 to be repeated in
the top of the Sheet1 as well as Sheet2,Sheet3 and other sheets in the
workbook.

On Oct 8, 10:16*am, Subodh wrote:
On 5 Oct, 14:18, Gord Dibben <gorddibbATshawDOTca wrote:





Using VBA code you can set the same print range and rows torepeatat top on
each sheet in grouped sheets.

See this google search result with Dave Peterson and myself posting. *The
print area code is from Bob Flanagan.

http://snipurl.com/106kz

Gord

On Mon, 5 Oct 2009 06:12:40 -0700 (PDT), Subodh wrote:
On Sep 23, 12:02*am, Gord Dibben <gorddibbATshawDOTca wrote:
Do you mean when printing you want to set "rows torepeatat top" ?

You cannot do this with grouped sheets.

You would require VBA macro to perform that operation.

Gord Dibben *MS Excel MVP

On Tue, 22 Sep 2009 09:22:29 -0700 (PDT), Subodh
wrote:

I want torepeatthe same text in thetitlesacross multiple sheets of
a workbook.
I grouped the sheets but the pagesetup shows the options under the
Sheet Tab Disabled.
I want toprinttitlesby repeating the same text on the top of all
the workbook.
Is there any method i can do this.
Copying the requiredtitlesto multiple sheets won't be a good option
because each workbook contains many sheet and there are several
workbooks.
Thanks in advance.- Hide quoted text -

- Show quoted text -

* Has any one got VBA code for this- Hide quoted text -

- Show quoted text -

This worked but not as i required. This sets the same print range and
rows to repeat at top on
each sheet in grouped sheets. ie. Rows 1:3 in each of each
Sheet1,Sheet2.............. are repeated in their respective pages.
But what i need is to repeat the Rows 1:3 of Sheet 1 to be repeated in
the top of the Sheet1 as well as Sheet2,Sheet3 and other sheets in the
workbook.- Hide quoted text -

- Show quoted text -