Fix Excel Ignoring Default Font in New Workbooks
Question details
Excel keeps using Calibri instead of the user's preferred font even after changing the default font in the General Options menu.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Creating a new workbook and expecting the newly configured default font to apply automatically.
- Observed behavior
- New workbooks continue to use the old default font because startup templates or creation methods override the general application settings.
Before modifying system folders or relocating templates, ensure that Microsoft Excel is completely closed to prevent file access errors.
Remove or Relocate Conflicting Startup Templates
Clear the XLSTART folder to prevent custom templates from overriding Excel's general font settings.
When Excel launches, it automatically loads any templates found in the XLSTART folder. If a file named Book.xltx is present, its internal formatting dictates the default font for new workbooks, rendering your File Options changes ineffective.
Ensure all active Excel windows and processes are completely closed to release file locks on the startup templates.
Open File Explorer in Windows. Click on the address bar, type %appdata%\Microsoft\Excel\XLSTART, and press Enter.
Look for a file named Book.xltx or similar template files. Right-click the file, select Cut, and paste it to your Desktop or another backup folder outside of the Excel directory.
Launch Microsoft Excel and create a new blank workbook. Type in any cell to check if the default font has now reverted to your preferred selection.
Re-apply Default Font Settings in Excel Options
Refresh your default font settings after clearing out conflicting startup templates to ensure Excel registers the change.
Try WPS Office for a Bug-Free Spreadsheet Experience
If Microsoft Excel's startup templates continue to override your preferred settings or system folders prove difficult to manage, consider switching to WPS Office. It provides a lightweight, highly compatible alternative with straightforward settings for default fonts and templates.
- 1. Download and Install: Visit the official WPS website to download the free WPS Office suite and run the quick installation on your device.
- 2. Open Existing Excel Files: Launch WPS Spreadsheet and seamlessly open your existing .xlsx or .xls files with full formatting and formula preservation.
- 3. Set Default Font Easily: Navigate to the settings menu in WPS Spreadsheet to choose your preferred default font without worrying about hidden template conflicts.
Frequently Asked Questions
Why does Excel ignore my default font setting?
Excel prioritizes formatting from custom startup templates, such as Book.xltx, stored in the XLSTART folder. If this template is set to Calibri, it will automatically override the default font you configured in the General Options.
Where is the XLSTART folder located on Windows?
The XLSTART folder is typically located in your user AppData directory. You can quickly access it by pasting %appdata%\Microsoft\Excel\XLSTART directly into the File Explorer address bar.
How do I change the default font for new Excel sheets only?
You can create a customized template with your preferred font, name the file Sheet.xltx, and save it in the XLSTART folder. This ensures that anytime you insert a new worksheet into an existing workbook, it adopts your customized formatting.
Will changing the default font affect my previously saved workbooks?
No, modifying the default font setting or deleting the Book.xltx startup template only applies to newly created workbooks. Your existing Excel files will retain their original fonts and formatting.
