Posted on 1 Comment

How to change the default hyperlink font face/size in Excel

Microsoft Excel

I was having a problem with the cells containing hyperlinks –  the font was changing automatically into the default one (even though I have selected all cells and applied a different font).
In order to configure Excel to use the same font face/size as the one you selected for the entire sheet (or group of cells) you need to create a new default template that will load at startup. They didn’t make it easy to do in Office 2007! But here’s how:

  1. Open a new blank worksheet.
  2. Insert > Hyperlink > Paste in any link
  3. Home > Styles > Right click on the ‘Hyperlink style’ > Modify > Set your font options
  4. You probably will want to do the same for the ‘Followed Hyperlink’ style
  5. Delete the hyperlink.
  6. File > Save As > Other formats
  7. Browse to “%APPDATA%MicrosoftExcelXLSTART” (Copy/Paste that into the File name field and press Enter to get there easily)
  8. Save as type: Excel Template (.xltx)
  9. File name: Book.xltx

change hyperlink font in Excel



 

Now whenever you start Excel or create a new workbook, the hyperlink font should be the one you choose.
This Microsoft support article helped me: http://support.microsoft.com/kb/822107 look here for where to save templates for Office 2003, or to see other ways of loading your template.

 

1 thought on “How to change the default hyperlink font face/size in Excel

  1. This didn’t work for me. First, I didn’t have STYLE as a choice on my HOME tab. Then, when I figured out how to add it (which had to go in a custom choice), the HYPERLINK is not a choice in the STYLES to modify. I did try to right click on a different one and the only choice I had was to “add gallery to quick access bar”.

Leave a Reply

Your email address will not be published. Required fields are marked *