Excel Headers and Footers 1

[Scott24x7]

I frequently make workbooks that have multiple tabs, and when I want to print those tabs, I want them to all have the same header and footer properties (logos, version number, project name, etc.) I do this by going to each sheet, clicking on the Page Setup option (in Excel 2007 or 2010) and then manually enter the header and footer information. Is there a way to do this once, and have all the pages "inherit" the same values?

Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[SkipVought]

Hi,

Select multiple sheets and then set your page parameters.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Scott24x7]

Skip,
You've been useful to me (and 1000's of others) many times, but that has to be the single largest time saver you've ever given me. (And probably most ever on this site). I don't know why it never occurred to me (after more years than I care to admit!) that you could select multiple sheets in a workbook at a time, and apply settings across them... This is a huge help to me not only in this instance, but in lots of other cases. Really, I wish I could give this post a 10 star rating. Thanks very much. (As they say, you learn something new every day... but this one is better than most!)
Cheers!


Best Regards,
Scott

"Everything should be made as simple as possible, and no simpler."

 

[SkipVought]

"Go ahead! Make...."

"Well, pilgrim, ya already did!"

Sorry about the mixed metaphors. ;-)

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}