Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.