headers to appear same on all sheet, need a way

Can't seem to find a way to make all headers the same on multiple sheets. It
may be that Excel has a setting which toggles back and forth from "all
headers individually different" to "all headers (and footers) the same".

Any suggestions?

Thank you for any help. Perhaps there's a macro someone may know of, if no
setting comes with the stock program.

John Cole

Hi John
try selectiong all sheets (hold down the SHIFT key while selecting
them) and change the header/footer in the pagesetup.

Note: This will change all page settings for all sheets


--
Regards
Frank Kabel
Frankfurt, Germany


J C C wrote:
Can't seem to find a way to make all headers the same on multiple
sheets. It may be that Excel has a setting which toggles back and
forth from "all headers individually different" to "all headers (and
footers) the same".

Any suggestions?

Thank you for any help. Perhaps there's a macro someone may know of,
if no setting comes with the stock program.

John Cole

Yes, Frank, worked like a charm. Also works on footers, too. (of course).
Very good tip.

Great to hear from you, from across the pond. I'm in San Francisco area.

Thanks,

John

"Frank Kabel" wrote in message
...
Hi John
try selectiong all sheets (hold down the SHIFT key while selecting
them) and change the header/footer in the pagesetup.

Note: This will change all page settings for all sheets


--
Regards
Frank Kabel
Frankfurt, Germany


J C C wrote:
Can't seem to find a way to make all headers the same on multiple
sheets. It may be that Excel has a setting which toggles back and
forth from "all headers individually different" to "all headers (and
footers) the same".

Any suggestions?

Thank you for any help. Perhaps there's a macro someone may know of,
if no setting comes with the stock program.

John Cole

Hi
thanks for your feedback :-)

--
Regards
Frank Kabel
Frankfurt, Germany


J C C wrote:
Yes, Frank, worked like a charm. Also works on footers, too. (of
course). Very good tip.

Great to hear from you, from across the pond. I'm in San Francisco
area.

Thanks,

John

"Frank Kabel" wrote in message
...
Hi John
try selectiong all sheets (hold down the SHIFT key while selecting
them) and change the header/footer in the pagesetup.

Note: This will change all page settings for all sheets


--
Regards
Frank Kabel
Frankfurt, Germany


J C C wrote:
Can't seem to find a way to make all headers the same on multiple
sheets. It may be that Excel has a setting which toggles back and
forth from "all headers individually different" to "all headers
(and
footers) the same".

Any suggestions?

Thank you for any help. Perhaps there's a macro someone may know
of, if no setting comes with the stock program.

John Cole