Footer defaults

J

Joe S.

I use a consistent protocol for footers on my reports but would like those
footers to exist in every file I create. Is there some way to make them the
default?
 
F

Frank Kabel

Hi
create a new workbook with this footer and save this as a template
(*.xlt file)
 
P

Peo Sjoblom

Yes, start a new blank woorkbook. do file>page setup and header/footer,
customize it the way you want. Finally save as Book.xlt in the startup
folder (xlstart)


Regards,

Peo Sjoblom
 
A

Art

Try setting up a default sheet. I'm never sure exactly where this thing
goes, but on my machine it's in c:\Program Files\Microsoft Office\Office
10\XLStart\book.xlt

If book.xlt isn't there you can create one. If all works well, whatever you
set up in this template will be used when you create a new worksheet. You
can set up your default print headers and footers, styles, etc.

It may live someplace different on your machine.

If you need to create one from scratch -- just open a new xls file. Make
the adjustments you want (say to footers), and save as a template in that
folder.

Art
 
G

Gord Dibben

Joe

I would suggest you record a macro while doing your setup then store that
macro in your Personal.xls. See below for Chip Pearson's header/footer
macros.

Alternative.......

Open a new workbook. Customize as you wish. 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>Workbook.

Existing workbooks are not affected by these settings. Footers for them will
have to be done manually or via macro(see Chip Pearson reference below)

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).

If you want a macro to set headers/footers see Chip Pearson's site for code.

http://www.cpearson.com/excel/headfoot.htm

Gord Dibben Excel MVP
 
Top