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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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 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
"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" <[email protected]>
wrote:
>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
>
>
>"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" <[email protected]>
> wrote:
>
> >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
> >
> >
> >"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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks