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	Open Doors is a Fun Logic-Based Flash Game Split Large Files into Smaller Pieces using GSplit How to Connect Multiple Computers to One Monitor Make Any Web Page Printer Friendly with Printee Our Favorite Finder Icon JumpLaunch Uses Windows 7 Jump Lists as a Launcher
Latest Software Reviews	Super User Daily
PCmover Professional Spyware Doctor + Antivirus 2010 Cakewalk Guitar Tracks Pro USB BitDefender Total Security 2010	64-bit Windows 7 can only use 3.25GB of RAM instead of 4GB? How to connect a xp laptop with a vista laptop wirelessly? Firefox search field button is broken Two monitors in vertical position as a dual monitor screen for a laptop
Geek Arcade	Popular Forum Threads
Open Doors Boombot Demolition City Heavy Weapons	No pop out sidebar in windows 7? Logon studio vista did not change image, automically help!! GEFORCE 9400 GT 512MB PCI E HDCP HDMI GRAPHICS CARD (Solved) - CPU usage very high

Comments (14)

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.