How do I make the custom headers and footer repeat on every works.

C

Chrisod

Please help? When I create a custom header or footer I have to do it for
every worksheet in Excel. Is there any way I can force it to add it to all
worksheets?
 
P

Peo Sjoblom

Before you apply the header, group the sheets (click the 1st sheet, hold down
the shift key and click the last), when you are done don't forget to ungroup
the sheets


Regards,

Peo Sjoblom
 
C

Chrisod

Thanks for that it worked a treat.
Chrisod

Peo Sjoblom said:
Before you apply the header, group the sheets (click the 1st sheet, hold down
the shift key and click the last), when you are done don't forget to ungroup
the sheets


Regards,

Peo Sjoblom
Click to expand...
 
Top