You can change the default hyperlink text styles in a workbook by formatting the Hyperlink or Followed Hyperlink cell styles. Here's how:
Select the cell with the hyperlink. On the Home tab, right-click the Hyperlink style and select Modify.
Tip
If you don't see the Hyperlink style, click the arrow to expand the style gallery.
In the Style box, click Format.
Click Font, choose your formatting options, and click OK.
Click OK to close the Style box. You can also change the appearance of hyperlinks that you clicked by using the preceding steps for the Followed Hyperlink style.
Note
Changes you make to Hyperlink or Followed Hyperlink styles apply 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.
Create a new workbook by selecting File > New > Blank workbook.
Right-click a cell and select Hyperlink.
Keyboard Shortcut: Press Ctrl + K.Type the hyperlink text you want displayed in the Text to display box.
Type a link address in the Address box.
Select the cell with the hyperlink and on the Home tab, select Cell Styles.
Depending on which style you want to change, right-click Followed Hyperlink or Hyperlink and select Modify.
In the Style box, select Format and on the Font tab, set your hyperlink font style options.
Select the cell with the hyperlink text and press Delete.
Select File > Save As and browse to the My Templates folder on your computer.
Note
The My Templates folder is usually located at C:\Users\Public\PublicDocuments. If you don't see it, add a new folder named My Templates.
In the File name box, type a name for your template.
Under Save as type, select Excel Template and select Save.
The next time you create a workbook, select File > New > Personal and open your template.
For more on using hyperlinks, see Work with hyperlinks in Excel.
Learn more about saving a workbook as a template.