Help with Headers and Footers
 

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?

Help with Headers and Footers
 

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

On Mon, 4 Jun 2007 02:43:00 -0700, courtney
wrote:

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?