Header or Footer to Multiple Worksheets Simultaneously

J

John

Hi Khuff
Press>Ctrl and select your worksheets (Tabs) then goto>View>Header&Footer
and put the information you want.
HTH
John
 
G

Gord Dibben

Just a note of caution.

This will also change all other print settings to same as active sheet.

With the exception of print area and rows to repeat at top.


Gord Dibben MS Excel MVP
 
K

khuff

Works like a champ!

Thanks John!

John said:
Hi Khuff
Press>Ctrl and select your worksheets (Tabs) then goto>View>Header&Footer
and put the information you want.
HTH
John
 
K

khuff

Good addition to the above, Thanks Gord

Gord Dibben said:
Just a note of caution.

This will also change all other print settings to same as active sheet.

With the exception of print area and rows to repeat at top.


Gord Dibben MS Excel MVP
 
Top