Change the font format for hyperlinks

You can change the default hyperlink text styles in a workbook by formatting the Hyperlink or Followed Hyperlink cell styles. Here's how:

  1. Click the cell with the hyperlink. On the Home tab, right-click the Hyperlink style and pick Modify.

    The Hyperlink Style in the fonts gallery

    Tips: If you don't see the Hyperlink style, click the arrow to expand the style gallery.

    click the down arrow in the fornt style gallery to expand view

  2. In the Style box, click Format.

  3. Click Font, choose your formatting options and click OK.

  4. Click OK to close the Style box.

    You can also change the appearance of hyperlinks that were clicked by using the above steps for the Followed Hyperlink style.

    Note: Changes made to Hyperlink or Followed Hyperlink styles are applied to all hyperlinks in the current workbook. You can't change the appearance of individual hyperlinks.

Save hyperlink cell styles for future workbooks

To reuse your hyperlink styles in new workbooks, create a template with your preferred hyperlink styles.

  1. Create a new workbook by clicking File > New > Blank workbook.

  2. Right-click a cell and pick Hyperlink.

    Keyboard Shortcut: Press Ctrl + K.

  3. Type the hyperlink text you want displayed in the Text to display box.

  4. Type a link address in the Address box.

  5. Click the cell with the hyperlink and on the Home tab, click Cell Styles.

  6. Depending on which style you want to change, right-click Followed Hyperlink or Hyperlink and pick Modify.

    Cell style formatting options
  7. In the Style box, click Format and on the Font tab, set your hyperlink font style options.

  8. Click the cell with the hyperlink text and press Delete.

  9. Click File > Save As and browse to the My Templates folder on your computer.

    Note: My Templates folder is usually located at C:\Users\Public\PublicDocuments. If you don't see it, just add a new folder named My Templates.

  10. In the File name box, type a name for your template.

  11. Under Save as type, pick Excel Template and click Save.

  12. The next time you create a workbook, click File > New > Personal and open your template.

    Click New and Personal to find your new template

For more on using hyperlinks, see Hyperlinks in worksheets.

Learn more about saving a workbook as a template.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×