Formatting (2000)

Topic

New Reply

In Tools / Options my default font is set to Arial. If I open a new Workbook then all the sheets are in Arial Font.

My problem is with existing workbooks. Sometimes when I add a Worksheet into an existing Workbook the new sheet is added in Courier font.

Is there some setting somewhere that can be changed to solve this problem?

Any help will be appreciated

Thank you

Kobus

Reply | Quote

Replies

If the Normal style of an existing workbook has been set to use Courier, a new worksheet will use that font too. You can force a new workbook to use Arial as follows:
– Create a new workbook. Delete all worksheets except one.
– Set up the worksheet the way you want (styles, fonts, header/footer) but don’t enter any data in it.
– Save it as a template named Sheet.xlt in your XLSTART folder*.
– From now on, inserting a new worksheet will use Sheet.xlt as template.

* Note: XLSTART may be inside a hidden folder, so make sure that hidden files and folders are displayed (this is a setting in the View tab of Tools | Folder Options… in Windows Explorer.)

Reply | Quote

Hans

Thank you very much more the advice. I have done that now, but it do not insert a worksheet in the existing workbook with the new formatting.

Is there any way in forcing the existing workbook to open a new worksheet with the new formatting?

Regards

Kobus

Reply | Quote

Hello Kobus,

You can test if the template works at all as follows:
– Open it.
– Enter some text in cell A1.
– Save and close the template.
– To be on the safe side, quit and restart Excel.
– It should come up with a new blank workbook. Select Insert | Worksheet.
Does the new worksheet contain the text you typed in cell A1?

If not, check the following:

Make sure that the template you created is named correctly. On an English language system, it is Sheet.xlt, but the name is language dependant; for instance, on my Dutch system, it must be Blad.xlt, and on an Italian system, it would be Foglio.xlt.
Also make sure that the template is stored in the correct location. By default, Excel tries to store templates in the user templates folder, but this special template must be stored in the XLSTART folder. On my system, there are two such folders:
C:Documents and SettingsHansVApplication DataMicrosoftExcelXLSTART (where HansV is my Windows username)
C:Program FilesMicrosoft OfficeOffice10XLStart (I am using Office XP)
The Sheet.xlt file works in either of these.

Reply | Quote

Hans

Thank you very much. My mistake was that I did not name the sheet as Sheet.xlt, but as test1.xlt. I did however stored it in the correct folder.

After deleting the wrongly named sheet and stored it with the correct name it worked exactly as you said.

Dit help baie as daar slim ouens soos jouself is.

Regards

Kobus

Reply | Quote

Kobus,

Dank vir jou vriendlike woorde.

Reply | Quote

Kobus,

Dank vir jou vriendlike woorde.

Reply | Quote

Hans

Thank you very much. My mistake was that I did not name the sheet as Sheet.xlt, but as test1.xlt. I did however stored it in the correct folder.

After deleting the wrongly named sheet and stored it with the correct name it worked exactly as you said.

Dit help baie as daar slim ouens soos jouself is.

Regards

Kobus

Reply | Quote

Hello Kobus,

You can test if the template works at all as follows:
– Open it.
– Enter some text in cell A1.
– Save and close the template.
– To be on the safe side, quit and restart Excel.
– It should come up with a new blank workbook. Select Insert | Worksheet.
Does the new worksheet contain the text you typed in cell A1?

If not, check the following:

Make sure that the template you created is named correctly. On an English language system, it is Sheet.xlt, but the name is language dependant; for instance, on my Dutch system, it must be Blad.xlt, and on an Italian system, it would be Foglio.xlt.
Also make sure that the template is stored in the correct location. By default, Excel tries to store templates in the user templates folder, but this special template must be stored in the XLSTART folder. On my system, there are two such folders:
C:Documents and SettingsHansVApplication DataMicrosoftExcelXLSTART (where HansV is my Windows username)
C:Program FilesMicrosoft OfficeOffice10XLStart (I am using Office XP)
The Sheet.xlt file works in either of these.

Reply | Quote

Hans

Thank you very much more the advice. I have done that now, but it do not insert a worksheet in the existing workbook with the new formatting.

Is there any way in forcing the existing workbook to open a new worksheet with the new formatting?

Regards

Kobus

Reply | Quote

If the Normal style of an existing workbook has been set to use Courier, a new worksheet will use that font too. You can force a new workbook to use Arial as follows:
– Create a new workbook. Delete all worksheets except one.
– Set up the worksheet the way you want (styles, fonts, header/footer) but don’t enter any data in it.
– Save it as a template named Sheet.xlt in your XLSTART folder*.
– From now on, inserting a new worksheet will use Sheet.xlt as template.

* Note: XLSTART may be inside a hidden folder, so make sure that hidden files and folders are displayed (this is a setting in the View tab of Tools | Folder Options… in Windows Explorer.)

Reply | Quote