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
 
You must log in or register to reply here.

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

Similar Threads

No More New Fonts May Be Applied To This Work Book 2
Header/Footer to update on all sheets 5
Change Header on Multiple Sheets without Changing Other Formatting 1
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0
Inserting the same header/footer on all worksheets in a workbook 7
Different headers, same footers on multiple worksheets 2
Headers and Footers size 2
header and footer to appear on all sheets within the workbook 1

Back
Top