Universal Footers

  • Thread starter Thread starter Robert
  • Start date Start date
R

Robert

Is there a way to create a univerals footer format, e.g.,
file name, tab name, date-- that would apply by default to
all files? Thanks
 
Hi Robert
you can create a new template (search the Excel help for 'Template')
and design the headers/footers as you like.
Base each new file on this template
 
Robert

For all "New" files, make a default Template workbook with your footer
settings.

Open a new workbook, format as you wish then Save As>File Type>Template(*.xlt)

Name it BOOK. Do not add the extension .xlt(Excel will look after that).

Store it in your XLSTART folder.

You can also store a SHEET.XLT in the XLSTART folder to become the default
Insert>Worksheet.

For existing files you would need some VBA to set all sheets footers as you
wish.

Chip Pearson has various coding for this at.......

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

Gord Dibben Excel MVP
 
Back
Top