default footer for all new Excel books?

[Hanne]

Is there a way to set a footer as default any time you open a new Excel
workbook?
I'm using 2007

 

[Tim879]

Not sure with 2007, but with all other excel versions... if you have a
personal.xls file then you can store your default footer there.

go to Window -> Unhide and select personal.xls.

set the footer as you want and then re-hide the workbook (Window ->
Hide)

if you don't have a personal.xls file... you can do the following to
create one...

-> Close any and all open Excel workbooks
-> Start Excel
-> Click menu item Tools|Macro
-> Click Record New Macro...
-> Click the down arrow In the "Store macro in:" list box
-> Click on Personal Macro Workbook
-> Click OK
Do something simple to create the macro...
-> Click in cell B1
-> Press the Delete key
-> Click in cell A1
-> Click on the square button in the Stop recording tool
-> Click the X in the top right hand corner of the Excel window to
close it (or press <Alt><F4>)
-> Click Yes to respond to "Do you want to save the changes you made
to the Personal Macro Workbook? If you click Yes, the macros will be
available the next you start Microsoft Excel -
-> Click No to respond to "Do you want to save the changes you med
to 'Book1'?
Start Excel
(Copied from http://techinfo.laurenceholbrook.com/CreateUsePersonalWorkbook.html)

 

[Dave Peterson]

I bet you meant to suggest using book.xlt (In xl2007, you'd use *.xltx or
*.xltm depending on what you want)

The original poster can create a new workbook with the print settings they like
(including headers/footers). Store this file in the XLStart folder and each new
workbook created that uses this workbook template.

You can also create another file named sheet.xlt* that will be used as the basis
for any new worksheet added to an existing workbook.

Ron de Bruin has some notes here:

and here:
http://www.rondebruin.nl/sheettemplate.htm

 

[Dave Peterson]

Ps. the personal.xls(*) file that you described is usually used to contain
macros that the user wants available each time excel opens.

 

[Gord Dibben]

Not sure about 2007 version but this is the method for earlier versions.

Yes........create a template with the custom footer and use that template as the
basis for all new workbooks.

Open a new workbook. Customize as you wish. To set a footer for each sheet,
select a sheet then right-click and "select all sheets".

Enter your footer on the active sheet and will be done to all. Ungroup sheets
when done.

File>Save As Type: scroll down to Excel Template(*.XLT) and select. Name your
workbook "BOOK"(no quotes). Excel will add the .XLT to save as BOOK.XLT.

Store this workbook in the XLSTART folder usually located at........

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART

This will be the default workbook for File>New or the Toolbar button File>New or
CTRL + n

WARNING................Do not use File>New...Blank Workbook or you will get the
Excel default workbook.

NOTE: Existing workbooks are not affected by these settings.

You can also open a new workbook and delete all but one sheet. Customize as
you wish then save this as SHEET.XLT in XLSTART folder also. It now becomes
the default Insert>Sheet.

More can be found on this in Help under "templates"(no quotes).


Gord Dibben Excel MVP