Excel 2007 : Copying page settings (headers, footers, margins) to multiple workbooks

**Sapphire*1** · 03-29-2012, 08:42 PM

Hi Just new to Forum and so a post about an add-in to do the above in Excel 2007 but didn't know how to access. I have set up a standard sheet for headers, footers, margins and fit to page print that we want to use for our pricelists which are already created in a number of workbooks. Now I just want to overlay these settings onto all the pages in the old workbooks.

All help greatly appreciated (tried to do macro but have a bug I can't get pasted!!)

**JBeaucaire** · 03-30-2012, 02:49 AM

So you want to:

1) Open a workbook to the main sheet "template" that you want to use to apply various settings to other workbooks.
2) Open the files one at a time from a specified folder
3) Apply the formatting of the "template" to ALL worksheets in each opened workbook
4) Save the edited workbooks back to the same location

Settings to copy are:
Headers
Footers
Page Margins
Fit to page print

Anything else?

**JBeaucaire** · 03-30-2012, 03:04 AM

This is the basic idea, edit the actual PAGE SETUPS you want to transfer.

Please Login or Register  to view this content.

**Sapphire*1** · 06-22-2015, 08:58 PM

I know this is a belated thank you but can I say it is so simple when you know how? Thank you

**JBeaucaire** · 06-22-2015, 10:18 PM

Better late than never!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.