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.