Help with Headers and Footers

G

Guest

Is there a way to save headers and footers that can be used in different
excel books using drop down boxes when you go into custom headers/footers? I
know how to do it when worksheets are within workbooks but not betwen
workbooks? Also why is that when I cop files between workbooks the formats
often change - they dont keep the same page setups?
 
G

Gord Dibben

Headers and footers are saved with the workbook.

No global setting for these except the default ones.

What formatting features change when you copy a worksheet from one workbook to
another?


Gord Dibben MS Excel MVP
 

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

Headers and Footers size 2
headers footers 3
headers and footers 2
How do I suppress headers/footers in excel 2
Headers and Footers by VBA? 6
I cannot seem to save my reports with headers and footers. Please 1
Better support for dynamic content within headers and footers 1
Headers/footers don't show in Print layout 1

Top