headers to appear same on all sheet, need a way

  • Thread starter Thread starter J C C
  • Start date Start date
J

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
 
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
 
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
 
Back
Top