Changing the default Header & Footer

C

Craig

Hi,

Can anyone help with this letter query? What I want to
achieve is to be able to have a header and footer on
every Excel document that I use by default. I want the
header and footer to be the same on each page with every
file that I choose to open.

At the moment the only way I can achieve this is by
manually selecting the header and footer from with File -
Page Setup - Header/Footer. At the moment the Header and
Footer is set to "None" is there anyway of changing this
so it remembers it by default?

Thanks in advance...

Craig
 
J

Jim Rech

For all new workbooks you create (and all new worksheets you insert) you can
create a template that Excel will use. The templates can have any default
settings that you want, including print headers.

In Excel help search on "default workbook template" for how to set this up.
 

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

Header and Footer 5
Header and Footer 3
Change Header & Footer Info w/ Worksheet Option Buttons 1
Header/Footer to update on all sheets 5
Change Header on Multiple Sheets without Changing Other Formatting 1
How do I make a single header/footer common across all worksheets? 1
Header and Footer margins 1
Disabling the "&[Time]" or "&[T]" in Excel headers and footers 2

Top