Excel Default Font Keeps Changing: How to Fix the Default Workbook Template

Your Excel default font changes every time you start a new workbook. This happens because Excel is using a corrupted or incorrect default workbook template. The template file controls the initial settings for all new blank workbooks.

When this file is missing or damaged, Excel reverts to its factory settings, which often means the font changes back to Calibri 11. This article will show you how to locate, repair, or recreate the default template to permanently lock in your preferred font.

Why the Default Font Resets Itself

Excel uses a special template file named Book.xltx to define the standard layout for new workbooks. This includes the default font, font size, number format, column width, and other sheet properties. When you set your preferred font in Excel Options and click Set as Default, Excel writes those settings into this Book.xltx file.

The problem occurs when this template file becomes corrupted, is set to read-only, or is saved in the wrong location. If Excel cannot properly read from or write to the Book.xltx file, it ignores your custom settings and uses its built-in defaults instead. Another common cause is having a custom template location specified in Excel’s options, which takes precedence over the standard template.

How Excel Locates the Default Template

Excel looks for the Book.xltx file in a specific startup folder called XLSTART. The exact path varies by Windows and Office version. On Windows 11 with a standard Office installation, the path is typically C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART. If a file named Book.xltx exists here, Excel uses it. If not, Excel creates a new workbook based on its internal programming defaults.

Steps to Repair or Recreate the Default Template

Follow these methods in order. Start with the first method to check for a simple configuration issue before moving on to repairing the template file itself.

Method 1: Check for a Custom Template Location

1. Open Excel Options
   Click File > Options to open the Excel Options dialog box.
2. Navigate to Save settings
   In the left pane, click the Save category.
3. Clear the custom template path
   Look for the field labeled “Default personal templates location.” If a folder path is entered here, clear the text box completely. Click OK and restart Excel to see if new workbooks now use your correct default font.

Method 2: Delete the Corrupted Book.xltx File

1. Close Microsoft Excel completely
   Ensure all Excel windows are closed. Check the Windows Taskbar and Task Manager to confirm no Excel processes are running.
2. Open File Explorer to the XLSTART folder
   Press Windows Key + R, type %appdata% and press Enter. Navigate to Microsoft > Excel > XLSTART. If the XLSTART folder does not exist, the template file is not the cause.
3. Find and rename the template file
   Look for a file named Book.xltx or Book.xltm. Right-click the file and choose Rename. Change the name to Book_old.xltx. This deactivates the file without deleting it.
4. Set a new default font in Excel
   Open Excel. Go to File > Options > General. Under “When creating new workbooks,” set your preferred font and size. Click the “Set as Default” button.
5. Test the fix
   Close and restart Excel. Create a new blank workbook by pressing Ctrl + N. The new sheet should now use your chosen default font.

Method 3: Manually Create a New Default Template

1. Create a new workbook with your settings
   Open Excel to a blank workbook. Set the font, font size, and any other cell formatting you want as the default.
2. Save the file as an Excel Template
   Click File > Save As. Choose the location This PC. In the “Save as type” dropdown, select “Excel Template (*.xltx).”
3. Name and save the file
   Name the file exactly Book.xltx. Navigate to the XLSTART folder path mentioned earlier. Click Save.
4. Set the template as the default
   Close the template file. Open Excel again and go to File > Options > General. Confirm your font settings are correct and click “Set as Default.” This action writes the settings to your new Book.xltx file.

If the Default Font Still Changes

Excel Ignores Font Settings After Windows Update

A major Windows or Office update can sometimes reset folder permissions or registry keys. Run a quick repair of Microsoft Office. Open Windows Settings > Apps > Installed apps. Find Microsoft Office, click the three-dot menu, and select Modify. Choose Online Repair to refresh all Office files and settings.

Font Resets When Opening Files From Others

Workbooks received from other people may contain hidden styles or themes that override your default view. This does not mean your template is broken. To check, open the problematic file and go to Page Layout > Themes. If the theme is not “Office,” your default font will not apply. Change the theme to Office to see your standard font.

Multiple Users on One Computer Experience the Problem

Each Windows user profile has its own XLSTART folder and template. The fix must be applied while logged into each user account. A system administrator can deploy a company-wide template via a network location or Group Policy, which is a different setup process.

Manual Template Creation vs. Using Set as Default

Item	Using “Set as Default” Button	Manually Creating Book.xltx
Primary Use	Standard fix for most users	Advanced fix for persistent corruption
Process	Automatic file creation/update	Manual save and placement
File Location	User’s AppData XLSTART folder	Must be saved to XLSTART folder
Controls	Font, font size, sheet view	All workbook and sheet properties
Best For	Simple font and size changes	Setting default headers, print area, or macros

After fixing the template, your chosen default font will appear in every new workbook. If you need to change the font again later, simply use the Set as Default button in Excel Options. For more control, explore creating custom worksheet templates to pre-format entire sheets with company logos and standard tables.