automatically adding footer info

palfireisland

New Member
Joined
Mar 30, 2006
Messages
5
Hi

Is there anyway to set Excel to automatically add header or footer info to every workbook created eg Path, date, filename. I basically just want to force this rather than trying to get users to remember to add this.

Thanks
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
Is there anyway to set Excel to automatically add header or footer info to every workbook created
Yes:
  • Start Excel with a blank workbook
    Set up the header/footer info like you want
    Do a SaveAs
    In the "Save as type" pull-down, select Template (*.xlt)
    In the "Save in" box at the top, navigate to C:\Program Files\Microsoft Office\Office10\XLStart
    (note: I'm using Excel 2002, your path may differ, but you are looking for the XLStart directory)
    Save the template with file name of Book.xlt
The next time you start Excel it will automatically have the header/footer info.

Tip: If one already exists, rename the original Book.xlt to something else so you can return to the default if desired.
 

Forum statistics

Threads
1,136,652
Messages
5,677,008
Members
419,668
Latest member
DharmaK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top