How do I change properties for all new documents in Excel?

S

sdippell

I want to change the company name in all my new Excel documents. How do I
change the default properties information?

Thank you
 
G

Gord Dibben

You could go into Windows Registry and change the Company Name that was entered
when Office was installed.

Alternative..............

Open a new workbook.

Customize as you wish including File>Properties>Summary>Company where you would
type in a new name.

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 or the Toolbar button File>New

Do not use File>New...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

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


Gord Dibben Excel MVP

I want to change the company name in all my new Excel documents. How do I
change the default properties information?

Thank you

Gord Dibben MS Excel MVP
 
S

sdippell

I'll give it a try.
Thank you,
sdippell

Gord Dibben said:
You could go into Windows Registry and change the Company Name that was entered
when Office was installed.

Alternative..............

Open a new workbook.

Customize as you wish including File>Properties>Summary>Company where you would
type in a new name.

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 or the Toolbar button File>New

Do not use File>New...Blank Workbook or you will get the Excel default workbook.

Existing workbooks are not affected by these settings.

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


Gord Dibben Excel MVP



Gord Dibben MS Excel MVP
 
Top