Header or Footer to Multiple Worksheets Simultaneously
 

How do I do this?

Header or Footer to Multiple Worksheets Simultaneously
 

Hi Khuff
PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer
and put the information you want.
HTH
John
"khuff" wrote in message
...
How do I do this?

Header or Footer to Multiple Worksheets Simultaneously
 

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

On Thu, 29 Jan 2009 16:56:02 -0500, "John" wrote:

Hi Khuff
PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer
and put the information you want.
HTH
John
"khuff" wrote in message
...
How do I do this?

Header or Footer to Multiple Worksheets Simultaneously
 

Works like a champ!

Thanks John!

"John" wrote:

Hi Khuff
PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer
and put the information you want.
HTH
John
"khuff" wrote in message
...
How do I do this?

Header or Footer to Multiple Worksheets Simultaneously
 

Good addition to the above, Thanks Gord

"Gord Dibben" wrote:

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

On Thu, 29 Jan 2009 16:56:02 -0500, "John" wrote:

Hi Khuff
PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer
and put the information you want.
HTH
John
"khuff" wrote in message
...
How do I do this?

Header or Footer to Multiple Worksheets Simultaneously
 

You're welcome
John
"khuff" wrote in message
...
Works like a champ!

Thanks John!

"John" wrote:

Hi Khuff
PressCtrl and select your worksheets (Tabs) then gotoViewHeader&Footer
and put the information you want.
HTH
John
"khuff" wrote in message
...
How do I do this?