Template Issues

How to Make Custom Excel Styles Available in New Workbooks

Ayan MasoodAyan Masood Nov 13, 2026 869 views

Question details

The user wants custom Excel cell styles to be available automatically when creating new workbooks in Microsoft 365 and wants to understand why existing files do not receive those styles automatically.

How to Make Custom Excel Styles Available in New Workbooks
Product
Microsoft 365 Excel
Device & OS
not provided
Scenario
The user has created or wants to create custom cell styles in Excel and expects them to be available in every new workbook.
Observed behavior
Custom styles are not automatically added to existing workbooks; they only appear in new workbooks if a default template such as Book.xltx is configured.
Before you start

Close Excel before editing the startup folder, and make sure you can view hidden folders so you can access the AppData\Roaming\Microsoft\Excel\XLSTART path.

Solution 1Recommended

Save a Customized Workbook as Book.xltx in the Excel XLSTART Folder

Use this method when you want Excel to load your custom styles for new workbooks created with Ctrl+N or the New Workbook command.

Excel uses Book.xltx from the XLSTART folder as the default template for new workbooks. Existing workbooks are separate files and are not retroactively updated.

1
Open the XLSTART folder

Press Windows+R, enter %AppData%\Microsoft\Excel\XLSTART, and press Enter. If the folder does not exist, create it in the same location.

2
Create and customize a blank workbook

In Excel, create a blank workbook, apply the custom cell styles you want, and remove any sample data.

3
Save the workbook as Book.xltx

Click File > Save As, choose Excel Template (*.xltx), name it Book.xltx, and save it in the XLSTART folder.

4
Test with Ctrl+N

Close and reopen Excel, then press Ctrl+N or click File > New > Blank workbook to verify that the custom styles are available.

Save a Customized Workbook as Book.xltx in the Excel XLSTART Folder
New workbooks only: This template affects new workbooks only. Existing workbooks must be updated manually or by opening a custom template.
Free Microsoft Office alternative

Use WPS Spreadsheets to Manage Custom Styles and Templates Without Microsoft 365 Configuration Hassles

WPS Office offers a free, lightweight spreadsheet alternative that opens Excel files, preserves formatting, and lets you manage custom styles and templates with a familiar interface for a seamless migration.

  1. 1. Download WPS Office: Click Download WPS Office Free from the official WPS website and install WPS Office on your device.
  2. 2. Open an Excel workbook or template: Launch WPS Spreadsheets and open your .xlsx or .xltx file to continue working with the existing styles.
  3. 3. Save custom styles as a WPS template: Use Home > Cell Styles to manage styles, then click Menu > Save As and choose WPS Spreadsheets Template (*.et) or Excel Template (*.xltx) for new workbooks.
Create reusable custom styles and default templates for consistent formatting in new workbooks.Opens and saves Microsoft Excel .xlsx, .xls, and .xltx files without losing formatting.Free to download and lighter than Microsoft 365 for everyday spreadsheet tasks.Familiar ribbon and workbook interface for an easy migration from Excel.No subscription required to work with templates and styles.
microsoft office alternative - wps office

Frequently Asked Questions

Why aren't my custom styles automatically added to existing Excel workbooks?

Excel applies the default Book.xltx template only when creating new workbooks. Existing files remain unchanged, so you need to update them by copying styled cells or using Merge Styles.

Where is the XLSTART folder in Windows?

It is typically located at C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART. You can open it quickly by pressing Windows+R and entering %AppData%\Microsoft\Excel\XLSTART.

Does saving Book.xltx affect Excel's normal blank workbook?

Yes. When Book.xltx is saved in the XLSTART folder, Excel uses it as the basis for new workbooks created with Ctrl+N or File > New > Blank workbook.

Can I use WPS Office to manage custom styles and templates instead?

Yes. WPS Spreadsheets can create custom styles, save workbooks as templates, and open Excel files. It is a free alternative if you do not want to configure the Excel XLSTART folder.

What should I do if the XLSTART folder does not exist?

Create the folder at C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART, save your customized workbook as Book.xltx there, then restart Excel and test with Ctrl+N.