How-To Geek
Change the Default Font in Excel 2007
Excel 2007 uses the very nice Calibri font by default in Windows Vista, but if you’d like to use a different font or change the default size, you can easily adjust the setting in the Excel options screen.
First click on the Office Button and choose Excel Options in the lower right hand corner of the resulting menu.
Select the Popular tab on the left, and then in the middle of this window you can change the default font using the selection.


Now when you create a new worksheet, you’ll see that the font is set automatically to your new selection.

You can always change the font using the Ribbon as well, but it’s only active for the current worksheet.
Got Feedback? Join the discussion at discuss.howtogeek.com
Comments (33)
Programmer by day, geek by night, The Geek, also known as Lowell Heddings, spends all his free time bringing you fresh geekery on a daily basis. You can follow him on Google+ if you'd like.
- Published 07/17/07




Just as I needed :) Thanks!
That didn’t work for me. Made changes, closed Excel, re-opened and it was back to Clalibri and 11.
Thanks!
This helps a lot!
Worked great for me — thanks so much.
YES!!!!!!!!!!
Roger Vernon = like David it did not work for me and kept going back – would like more information
Regarding changing the font, I just discovered that, after selecting the font that I want, I had to click on the ‘OK’ button at the bottom. The button was hidden by the taskbar at the bottom and I couldn’t see it.
By right clicking on the taskbar and then unchecking ‘Lock the Taskbar’ the OK button was visible.
Thank you. This process was very helpful.
The problem still exist, its just a very simple steps but everytime I restart a new Excel, it still defaulted to Arial but if I open the excel options it is already on the desired font. I rebooted my whole pc, still same problem.
please help… not sure what david prejan is referring to regarding OK button being hidden. once you click the office button, the OK button is available already.
I appreciate the help, but as some of the others, changing the font in the word options area does not work for me also. My system keeps re-opening Excel with Calibri, font 11. I wonder if you found a solution for the others and what that might be? Thank you for any help, s. french
Thanks a lot
Thanks, very helpful indications!
This works for setting the default font for the spread sheet but it does NOT affect charts which continue to default to Calibri.
Thanks for that. Nice clear instructions and worked a treat.
Hi there,
i’d like to automatically open a blank excel worksheet formatted to 2 decimal places “(,) style” everytime I open excel or a new worksheet.
Regards
Abdul
how can we set the default font for comment in ms excel 2003 or 2007..
why do email addresses default to Calibri 11, even when the pitch selected for the worksheet is 10?
To add a new command to the Quick Access Toolbar is there any way to change the default Choose commands from ‘Popular Commands’ to ‘All commands’
tnx it works 4 me :-)
my excel file font has been corrupted
any one can help me?
(((( üýHÐTÐAP‘||ÐäÔ”Ð3R‘||ÐÔÑ ü‡öÌÐÉU‘|°Ñ Ñ Àøûýh $ÀÐAP‘|èÐÿÿÿ2‘|«‘|ë‘|Õ@Ò2‘|˜˜|Ò«‘|\Ôî|8‘|ÿÿÿÿ2‘|«‘|ë‘|XtXtHÒŒÔî|8‘|ÿÿÿÿ2‘|«‘|ë‘|@£ïwˆxE )))
i need help………………… plz
Finally, you have provided the necessary info that has been frustrating me FOREVER!! Thank you very, very much! I knew it had to be simple, but have never been able to figure it out.
I’m very relieved.
Just what i needed and looking for.
This instructions really solved my prob and answered my question.
Thanks so much.
Directions were simple and it worked for me.
THANKS!!!!!!!!!!! I hate Calibri!!!!
Dear Sir,
It worked well for me. That despite I run Excel on a different language. Thank you for your help.
Kind regards
Leopold B.
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.
Go to the xl start folder:
C:\Program Files\Microsoft Office\Office12\XLSTART
Open the file there and change the font to what you like.. anything except Calibri. lol
This should fix this stupid calibri setting permanently (at least when u open a new Excel sheet).
In some instances where you export to Excel from Access, it may still go to that silly Calibri setting.
BTW , calibri aint bad in emails I guess, but in Excel, we like our Arial. It is how we do it.
Thank you for the tip. I hate calibri too! :)
did not work. followed directions to the letter and still stays on default ms font
thanks
THnx a lot help me a lot..
itz not usefull for me, have to make changes again and again..
thanks ! great help !