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.

| More

This article was originally written on 07/17/07 Tagged with: Microsoft Excel, Microsoft Office

Daily Email Updates

You can get our how-to articles in your inbox each day for free. Just enter your name and email below:

Name:
Email:

Similar Articles	Tinyhacker - Tiny Geek Hacks
Make Excel 2007 Always Save in Excel 2003 Format Add Emphasis to Paragraphs with Drop Caps in Word 2007 Make Word 2007 Always Save in Word 2003 Format Make Fonts Less "Fuzzy" in Safari for Windows Make Excel 2007 Print Gridlines In Workbook File	Add 50 Pidgin Plugins With One Download Scroll Bars Only Have One Purpose? No Way! Tweak Your nVidia Video Card With Confidence The Webby Award Winners, All Best in Class Websites Generate Your Own Barcode Online Clean Up Old and Duplicate Bookmarks (Firefox)
Latest Software Reviews	Super User Daily
PCmover Professional Spyware Doctor + Antivirus 2010 Cakewalk Guitar Tracks Pro USB BitDefender Total Security 2010	Task manager: Windows XP RAM usage doesn't add up Clarify Windows Server 2008 licenses? Is there a stable email client or email client plugin that will support GMail-like conversations? Why are Outlook 2007 categories not being sent back on email replies?
Geek Arcade	Popular Forum Threads
Open Doors Boombot Demolition City Heavy Weapons	How do you remove Microsoft Office Trial to replaced by Microsoft Office Enterpr xp multiple problems. cut & paste, internet explorer (Solved) - DVD-ROM Problem. Find Host/Computer name with IP address

Comments (15)

1. October 4, 2007 1:30 pm
   Joy

   Just as I needed Thanks!

2. December 13, 2007 7:59 am
   David Prejean

   That didn’t work for me. Made changes, closed Excel, re-opened and it was back to Clalibri and 11.

3. August 27, 2008 1:19 am
   Fird

   Thanks!

   This helps a lot!

4. October 7, 2008 10:17 am
   Mary Ellen

   Worked great for me — thanks so much.

5. October 23, 2008 9:56 am
   Tina

   YES!!!!!!!!!!

6. February 25, 2009 12:32 pm
   Roger Vernon

   Roger Vernon = like David it did not work for me and kept going back – would like more information

7. February 26, 2009 7:00 am
   David Prejean

   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.

8. March 27, 2009 6:12 am
   CarlosG

   Thank you. This process was very helpful.

9. May 2, 2009 11:01 am
   Dante

   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.

10. May 5, 2009 7:24 am
    s. french

    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

11. May 5, 2009 11:33 pm
    Hong

    Thanks a lot

12. June 11, 2009 6:36 am
    O

    Thanks, very helpful indications!

13. September 12, 2009 6:53 am
    Joseph

    This works for setting the default font for the spread sheet but it does NOT affect charts which continue to default to Calibri.

14. October 7, 2009 7:30 pm
    Gav

    Thanks for that. Nice clear instructions and worked a treat.

15. November 10, 2009 1:23 am
    Abdul

    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