Excel guide · 5 min read
How to change the default font in Excel
Sample data
Every result on this page was calculated from this sheet by the same spreadsheet engine the Cellwise app uses.
| Row | A | B | C |
|---|---|---|---|
| 1 | You want to change | Where | Affects |
| 2 | Font for every new workbook | File > Options > General | New workbooks after a restart |
| 3 | Font in this workbook | Home > Cell Styles > Normal > Modify | Cells using the Normal style |
| 4 | Body and heading fonts | Page Layout > Fonts | This workbook, charts included |
| 5 | Everything a new workbook starts with | Book.xltx in XLSTART | New workbooks after a restart |
| 6 | Font on a Mac | Excel > Preferences > General | New workbooks after a restart |
| 7 | A few cells | Home > Font box | The selected cells only |
Which setting to change
Excel has several font settings, and most "it didn't work" complaints come from changing the right one in the wrong place. The sample table sums them up:
- New workbooks from now on: File > Options > General (Method 1).
- The workbook you have open, or one someone sent you: the Normal cell style (Method 2).
- A matching font for headings, body text and charts in one workbook: theme fonts (Method 3).
- New workbooks with your font plus your column widths, styles and print settings: a Book.xltx template (Method 4).
Method 1: File > Options > General
This sets the font that every new blank workbook starts with. It's the setting most people are looking for.
- Go to File > Options and stay on the General page.
- Under When creating new workbooks, open Use this as the default font and choose a font, such as Arial.
- Choose a size in Font size.
- Click OK. Excel tells you to close and restart Excel for the change to take effect.
- Close every Excel window, open Excel again and create a blank workbook to check.
What does Body Font mean in that box?
It's the default: use the body font of the workbook's theme. In current Microsoft 365 that shows as Aptos Narrow; older versions show Calibri 11. Picking a named font instead fixes it regardless of theme.
Can I change the default font in Excel for the web?
No. Microsoft says the default font for a workbook can't be changed in Excel for the web. You can still format the cells you select with the Font box on the Home tab.
Method 2: change the font in an existing workbook (Normal style)
The Options setting is copied into each workbook when it's created, as its Normal cell style. That's why your old files and anything a colleague sends you still open in the old font. To change a workbook that already exists, edit its Normal style.
- Open the workbook and go to Home > Cell Styles.
- Under Good, Bad and Neutral, right-click Normal and choose Modify.
- Click Format, go to the Font tab, choose the font and size, and click OK twice.
- Every cell that uses the Normal style changes, on every sheet. Save the workbook.
Why didn't some cells change?
Cells where someone picked a font by hand, or that use another style such as Heading 1, keep that formatting. Select them and pick Normal in Cell Styles, or set their font directly.
Why did my column widths change too?
Excel measures the standard column width in characters of the Normal font. A wider or larger font makes the standard columns and rows grow to fit.
Method 3: theme fonts for one workbook
Every workbook has a theme with a heading font and a body font. Cells on the default style, chart text and SmartArt follow them. Changing the theme fonts is the quickest way to restyle a whole report so the charts match the cells.
- Go to Page Layout > Fonts (in the Themes group).
- Pick a pair from the list, or click Customize Fonts to choose your own Heading font and Body font and give the set a name.
- Click Save. The workbook updates straight away.
Why didn't the theme font change my cells?
It only changes cells whose font is the theme's body or heading font. In the Font box those show with (Body) or (Headings) after the name. A font picked by name stays put.
Method 4: a Book.xltx template for everything else
If you want new workbooks to start with more than a font, such as your cell styles, column widths, headers and footers or a set number of sheets, save a template named Book in Excel's startup folder. Excel uses it for every new blank workbook.
- Create a blank workbook and set it up the way you want, including the Normal style font from Method 2.
- Go to File > Save As and choose Excel Template (*.xltx) as the file type.
- Name it Book, exactly.
- Save it in your XLSTART folder. Microsoft's example path is C:\Program Files (x86)\Microsoft Office\root\Office16\XLSTART; a per-user XLSTART folder under %appdata%\Microsoft\Excel also works.
- Restart Excel. New blank workbooks now start from your template.
How do I undo the template?
Delete or rename Book.xltx in XLSTART and restart Excel. New workbooks go back to the File > Options settings.
On a Mac
Excel for Mac keeps the setting in Preferences rather than Options. Microsoft notes it doesn't change existing workbooks, so use the Normal style there as in Method 2.
- On the Excel menu, click Preferences.
- Under Authoring, click General.
- Choose a font in Default font and a size in Font size.
- Close and restart Excel, then create a new workbook.
Common mistakes
Changing the Options font and expecting open files to update
It only applies to new workbooks after a restart. Edit the Normal style in existing files.
Not restarting Excel
Close every Excel window. The new default isn't picked up until Excel starts again.
Selecting the whole sheet and picking a font
That works but marks every cell as manually formatted, so theme changes no longer reach them. Changing the Normal style is cleaner.
Naming the template something other than Book
Excel only picks up Book.xltx in XLSTART for new workbooks. Other names are ordinary templates under File > New.
FAQ
What is the default font in Excel?
Current Microsoft 365 uses Aptos Narrow at size 11 through the Body Font setting. Older versions used Calibri 11.
Why does Excel keep changing my font back?
You're opening workbooks that were created with the old default, so their Normal style still uses it. Change the Normal style in each, or start new files after setting the default and restarting.
How do I change the default font size in Excel?
File > Options > General, then Font size under When creating new workbooks. Restart Excel. For an existing file, modify the Normal cell style.
Does the default font affect charts and comments?
Charts follow the theme fonts, so Page Layout > Fonts changes them. The Options setting changes cell text in new workbooks.
Related guides
- How to add borders in Excel
- How to use Format Painter in Excel
- Excel gridlines not showing (or missing in some cells): how to get them back
- How to indent text in Excel
- How to superscript and subscript in Excel
- How to turn on dark mode in Excel
- How to remove hyperlinks in Excel
Updated