headers to appear same on all sheet, need a way

[J C C]

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

 

[Frank Kabel]

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

 

[J C C]

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]

Hi
thanks for your feedback