Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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


    • 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 Work with hyperlinks in Excel.

Learn more about saving a workbook as a template.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?

Thank you for your feedback!