Pre-set headers and footers for new worksheets
 

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.

Look in Excel HELP for Template

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"robertwesley" wrote in message
...
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.

Make a blank spreadsheet with your preferences set up, then go to FileSave
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


"robertwesley" wrote:

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.

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

On Tue, 26 Apr 2005 11:50:04 -0700, "jake"
wrote:

Make a blank spreadsheet with your preferences set up, then go to FileSave
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


"robertwesley" wrote:

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.

genius!

excel thinks of everything!


"Gord Dibben" wrote:

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

On Tue, 26 Apr 2005 11:50:04 -0700, "jake"
wrote:

Make a blank spreadsheet with your preferences set up, then go to FileSave
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


"robertwesley" wrote:

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.