Setting up Default Headers/Footers in Excel


D

Dragon Lady

The powers that be have decided that all Excel worksheets that might be
shared with others will have a header or footer containing file path, date,
and other readily available info. I know how to add this info to a
header/footer in Excel, but it would be so much easier if my default workbook
already has this info embedded.

Any clue how to make this a default setup?
 
Ad

Advertisements

J

Jacob Skaria

Open a new workbook and set your footers/headers and name the book as
book.xlt and save it in your XLStart folder. When you click on the New Icon
on the standard toolbar a new workbook will be opened based on this settings

If this post helps click Yes
 
B

Bernie Deitrick

You can create a default sheet template (Sheet.xlt) and a default workbook template (Book.xlt) and
store them in your default template folder, and Excel will use them to create new sheets and
workbooks. Any content and formatting (fonts, headers, etc.) are stored with the templates.

HTH,
Bernie
MS Excel MVP
 
Ad

Advertisements

D

Dragon Lady

THank you. That does it!
--
Hic Sont Draconis


Jacob Skaria said:
Open a new workbook and set your footers/headers and name the book as
book.xlt and save it in your XLStart folder. When you click on the New Icon
on the standard toolbar a new workbook will be opened based on this settings

If this post helps click Yes
 

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

Top