Repeat the titles across multiple sheets of a workbook.


S

Subodh

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

Advertisements

G

Gord Dibben

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
 
S

Subodh

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



- Show quoted text -

Has any one got VBA code for this
 
G

Gord Dibben

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
 
S

Subodh

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






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

Advertisements

S

Subodh

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 -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top