+ Reply to Thread
Results 1 to 2 of 2

How do I set the default font for hyperlinks in Excel?

  1. #1
    antbedy
    Guest

    How do I set the default font for hyperlinks in Excel?

    When I type an email or webaddress in an Excel spreadsheet, and Excel
    converts it automatically to a hyperlink, it also changes the font to Arial.
    I would prefer that it remain in Times New Roman. How can I turn off this
    feature, or change the default so that the hyperlink is shown in Times New
    Roman?

  2. #2
    Gord Dibben
    Guest

    Re: How do I set the default font for hyperlinks in Excel?

    Format>Style>Style Name>Hyperlink>Modify.

    Change Font here.

    Open a new workbook. Customize as you wish, including your Styles. 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

    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 MS Excel MVP

    On Mon, 24 Apr 2006 12:05:02 -0700, antbedy <[email protected]>
    wrote:

    >When I type an email or webaddress in an Excel spreadsheet, and Excel
    >converts it automatically to a hyperlink, it also changes the font to Arial.
    >I would prefer that it remain in Times New Roman. How can I turn off this
    >feature, or change the default so that the hyperlink is shown in Times New
    >Roman?



+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1