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?

Take a look he

http://www.mcgimpsey.com/excel/fullnameinfooter2.html

In article ,
"Chrisod" wrote:

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?

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

"Chrisod" wrote:

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?

Thanks for that it worked a treat.
Chrisod

"Peo Sjoblom" wrote:

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

"Chrisod" wrote:

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?