copy custom header from one worksheet to another in same workbook

Could you please let me know simply how to copy and paste the custom header
from one workshheet of a workbook on to one or two additional worksheets of
the same workbook which do not have that header

Thank you very much
Aamir

Select worksheet with custom header.

CTRL + Click on other sheet or sheets to group them

On active sheet go to File>Page Setup and do what you wish to the header.

Will be done to all sheets selected.

DO NOT FORGET to ungroup the sheets when done.


Gord Dibben MS Excel MVP

On Tue, 20 Jun 2006 11:24:03 -0700, Aamir <[email protected]>
wrote:

>Could you please let me know simply how to copy and paste the custom header
>from one workshheet of a workbook on to one or two additional worksheets of
>the same workbook which do not have that header
>
>Thank you very much
>Aamir