Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formatting (2000)

    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
    Regards
    Kobus

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting (2000)

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

  3. #3
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting (2000)

    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
    Regards
    Kobus

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting (2000)

    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:
    Cocuments 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.

  5. #5
    Star Lounger
    Join Date
    Jan 2004
    Posts
    77
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formatting (2000)

    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
    Regards
    Kobus

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Formatting (2000)

    Kobus,

    Dank vir jou vriendlike woorde.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •