How to Set Default Font in Excel (And What Changes When You Do)
Every new Excel workbook opens with the same font — Calibri at 11pt — unless you tell it otherwise. If you're constantly reformatting cells to match your preferred style, changing that default once saves you the repetitive work on every file you create going forward.
Here's how it works, what it actually affects, and why the right choice depends more on your workflow than most tutorials let on.
What "Default Font" Means in Excel
Excel's default font is the font applied automatically to every new cell in every new workbook. It's baked into the Normal style, which is the baseline formatting template the application uses unless something overrides it.
Changing the default font doesn't reformat your existing workbooks. It only affects new workbooks created after the change is saved. That distinction matters if you're working across a team or managing files that need to stay consistent with older documents.
How to Change the Default Font in Excel 🖊️
The setting lives in Excel's general options, not in the font toolbar you use day-to-day.
On Windows (Excel 2016, 2019, Microsoft 365):
- Open Excel and go to File → Options
- Under the General tab, find the section labeled "When creating new workbooks"
- Use the Use this as the default font dropdown to select your preferred font
- Set the Font size in the field next to it
- Click OK
- Restart Excel — the change only takes effect after a full restart
On Mac (Excel for Mac, Microsoft 365):
- Open Excel and go to Excel → Preferences
- Click General
- Under "When creating new workbooks", change the Default font and Font size fields
- Quit and reopen Excel
After the restart, every blank workbook you open will use the new font automatically.
What the Default Font Actually Controls
It's worth knowing exactly what this setting reaches — and what it doesn't.
| Setting | Affected by Default Font Change? |
|---|---|
| New blank workbooks | ✅ Yes |
| Existing saved workbooks | ❌ No |
| Workbooks from templates | ❌ Depends on template settings |
| Charts and text boxes | ❌ Separate formatting rules |
| Headers and footers | ❌ Set independently |
| Shared/collaborative files | ❌ Each user's local setting applies |
This is why team environments sometimes encounter inconsistencies — one person's default font doesn't travel with the file when shared. The font displays correctly for recipients only if they have that font installed, or if Excel substitutes a fallback.
The Variables That Should Influence Your Choice
Changing the default is straightforward. Choosing the right default is where your specific context matters.
Readability vs. print output Fonts optimized for screen readability (like Calibri or Aptos, which replaced Calibri as Microsoft's new default in recent Microsoft 365 versions) don't always translate cleanly to print. If you regularly print reports or export to PDF, a font like Arial or Times New Roman may render more predictably across printers and PDF viewers.
Corporate or institutional standards Many organizations mandate specific fonts in documents for branding consistency. If your workplace uses a style guide, your personal Excel default should match — otherwise you'll spend time correcting formatting before sharing files.
Font availability across devices If you work on multiple machines or switch between Windows and Mac, verify the font exists on both platforms. Some fonts are Windows-only or Mac-only, meaning a file created with one default may display in a substituted font on a different OS. Fonts in the Microsoft core web fonts set (Arial, Verdana, Georgia, etc.) tend to be widely available.
Excel version differences 🖥️ Microsoft quietly shifted its default from Calibri to Aptos starting in late 2023 for Microsoft 365 subscribers. If you've recently updated and noticed the default font changed without your input, that's why. Users on perpetual license versions (Excel 2019, 2021) still default to Calibri.
Modifying the Normal Style as an Alternative
There's a second method for power users: editing the Normal style directly.
- On the Home tab, right-click Normal in the Styles gallery
- Select Modify
- Click Format → Font and set your preferred font
- Click OK
This approach updates the Normal style within the current workbook only, not globally. To push it to all new workbooks, you'd need to save a modified version as your default workbook template — a separate process involving saving a file named Book.xltx to Excel's startup folder.
That template method gives granular control beyond just the font: default column widths, number formats, sheet count, and more can all be locked into a template that opens every time you start a new file.
Why There's No Universal "Best" Default
Calibri became the default in 2007 because it was designed specifically for screen legibility at small sizes. Aptos was chosen by Microsoft in 2023 for similar reasons, with updated metrics for modern high-DPI displays. Arial is the go-to for print-heavy work. Fonts like Garamond or Georgia suit document-style spreadsheets.
None of those is universally better. Whether you're building financial models, data dashboards, client-facing reports, or internal trackers shapes which font actually serves you. Screen resolution, print frequency, whether your files stay internal or get shared externally, and whether you're working solo or inside a standardized workflow all push the right answer in different directions.
The mechanical steps are simple and reversible. The right font for your default is the part that depends entirely on how your setup actually operates.