How to Make Custom Excel Styles Available in New Workbooks
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.

- 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.
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.
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.
Press Windows+R, enter %AppData%\Microsoft\Excel\XLSTART, and press Enter. If the folder does not exist, create it in the same location.
In Excel, create a blank workbook, apply the custom cell styles you want, and remove any sample data.
Click File > Save As, choose Excel Template (*.xltx), name it Book.xltx, and save it in the XLSTART folder.
Close and reopen Excel, then press Ctrl+N or click File > New > Blank workbook to verify that the custom styles are available.

Update Existing Workbooks by Copying Styles or Using a Custom Template
Use this method when you need to apply custom styles to workbooks that were already created before the default template was saved.
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. Download WPS Office: Click Download WPS Office Free from the official WPS website and install WPS Office on your device.
- 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. 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.

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.




