Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For cells containing hyperlinks the font changes automatically into the default one (even though I have selected all cells and applied a different font).

How can you configure Excel to use the same font face/size as you selected for the entire sheet (or group of cells) and not the default font set in Excel (in Excel 2007 the font can be set in Excel Options | Popular tab | When creating new workbooks section).

enter image description here

share|improve this question
up vote 7 down vote accepted

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%\Microsoft\Excel\XLSTART" (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

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.

share|improve this answer
    
Thank you subman! Maybe if I tried harder I could've found the answer myself - pretty intuitive the Style section though... Thanks again! – Nicu Zecheru Aug 28 '09 at 9:25

You can modify the default Hyperlink within the Styles list. Right click on the Hyperlink style and select modify. Select format and set your font, color, size, underline, border, etc..

share|improve this answer
    
I wonder what the compatibility is for this answer. It's 100x simpler than the accepted answer. – Devil's Advocate Apr 6 at 16:16

You must log in to answer this question.

protected by Community Aug 6 '15 at 10:37

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .