Header or Footer to Multiple Worksheets Simultaneously

  • Thread starter Thread starter khuff
  • Start date Start date
Hi Khuff
Press>Ctrl and select your worksheets (Tabs) then goto>View>Header&Footer
and put the information you want.
HTH
John
 
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
 
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top