Default Font in Excel (Change Style, Size, and Color)

Last Updated: June 22, 2023
puneet-gogia-excel-champs

- Written by Puneet

Calibri is the default font style in Excel with a font size of 11 and black font color. And if you are using Mac, it’s Calibri with a font size of 11 also.

But there’s an option in Excel, to change the default font style if you want. You can change it for the current workbook, or you can change the default font for the entire application.

default-font-size-style-color

In this tutorial, you will learn to change the default font.

Change Default Font from Excel Options

  1. First, click on the “File” tab.
    go-to-file-tab
  2. After that, click on “Excel Options.
    click-excel-options
  3. Now, from the ‘general” options, go to “When creating new workbooks”.
    go-to-when-creating-new-workbooks
  4. From there, select the font from the “Use this as a default font”.
    select-the-font
  5. Next, change the size from the “Font size”.
    change-size-of-font
  6. In the end, click OK to save the settings and Excel will tell you to close and restart your Excel application.
    save-the-settings

And once you restart the Excel application, you will get the new default font with each new workbook you create.

new-default-font

This change in settings will not make any changes to the existing file which are already saved.

Use Font Themes for Multiple Default Fonts

If you want to have multiple default fonts, you can create a font theme that can help you to change the default font whenever you want.

  1. First, go to the Page Layout ⇢ Theme ⇢ Fonts.
    go-to-page-layout-tab
  2. Now, click on the Fonts drop-down and click on “Customize Fonts”.
    click-customize-fonts
  3. From the “Create New Theme Fonts”, specify the body font that you want to use.
    create-new-theme-fonts
  4. In the end, enter a name for the theme and click on the “Save” button to save the font theme.

You can create multiple themes and change the default font with a single click.

create-multiple-themes

Create a Template with the Default Font

If you need to change the default font while creating some specific workbooks, you can change the font and save it as a template. And, whenever you need to have that one specific font as default, you can create a new workbook using that template.

  1. First, change the default font by using the steps we have discussed above.
  2. Next, go to the “File” tab and use the Save As option.
    go-to-file-tab
  3. After that, from the “Save as type”, select “Template”.
    select-save-as-type-template
  4. Now, when you select “Excel Template” it will take to you to the location where you can save the Custom Office Templates.
    select-excel-template
  5. In the end, give a name to the template and click on the save button.
    give-name-to-template

Now, whenever you need to use it, simply open it, and save it again as a new file. You don’t need to make changes to the font style and size at all.