Pre-set headers and footers for new worksheets

[Guest]

how do I have a new excel spreadsheet always open with pre-set headers and
footers? There must be a way to do this. I am tired of going into each
spreadsheet I open and re-entering my preffered set up; headers and footers,
row height, etc.

 

[Niek Otten]

Look in Excel HELP for Template

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Make a blank spreadsheet with your preferences set up, then go to File>Save
As, call it 'Robert Wesley Template' or something similarly useful, then
(here's the clever bit) select 'Template(.xlt)' from the drop down File Type
menu. Now every time you make a new spreadsheet simply open the template
first. All you have to watch for is that a: you don't hit Save and save over
your template and b: when saving a new spreadsheet for the first time you
remember to change the file back to 'Excel Spreadsheet(.xls)'

Hope that's what you're looking for,

Jake

 

[Gord Dibben]

jake

Do not open the Template.XLT

Just open a workbook based upon that Template.

Then you don't have a chance to overwrite and also the workbook is
automatically an *.xls


Gord Dibben Excel MVP

 

[Guest]

genius!

excel thinks of everything!

jake

Do not open the Template.XLT

Just open a workbook based upon that Template.

Then you don't have a chance to overwrite and also the workbook is
automatically an *.xls


Gord Dibben Excel MVP