Template Issues

How to Add Custom Excel Cell Styles to Every New Workbook

Muhammad TalhaMuhammad Talha Nov 4, 2026 870 views

Question details

The user wants to configure Excel so that custom cell styles and number formats are automatically loaded and available every time a new blank workbook is created.

How to Add a Custom Excel Cell Style to Every New Workbook
Product
Microsoft Excel
Device & OS
Windows
Scenario
Setting up a default Excel workbook template to retain specialized cell formatting across all future new documents.
Observed behavior
By default, new workbooks only contain standard styles. A specific template needs to be saved in the system's hidden XLSTART folder to persist these customized formats.
Before you start

Ensure you have decided on the exact custom cell styles and number formats you want to use daily. Note that the %appdata% directory is hidden by default in Windows, but it can be accessed directly via the File Explorer address bar.

Solution 1Recommended

Create a Default Workbook Template in the XLSTART Folder

Define your custom styles in a blank workbook and save it as an Excel Template named Book.xltx inside the hidden XLSTART directory.

Excel uses the XLSTART folder to load startup files automatically. By placing a template named Book.xltx here, Excel will use it as the base structure for all new blank workbooks, ensuring your custom formats are always available.

1
Define Your Custom Styles

Open a new blank workbook in Excel. Use the Home tab to create and define the custom cell styles and number formats you want to be available globally.

2
Open the Save As Dialog

Click on File > Save As. In the file format dropdown menu, select 'Excel Template (*.xltx)'. If your workbook requires VBA macros, select 'Excel Macro-Enabled Template (*.xltm)' instead.

3
Navigate to the XLSTART Folder

In the File Name box or the address bar of the Save As dialog, type '%appdata%' and press Enter to bypass hidden folders. Navigate through the folders: Microsoft > Excel > XLSTART.

4
Save the Template

In the File Name box, type exactly 'Book.xltx' (or 'Book.xltm' for macro-enabled templates) and click Save. Make sure you are not saving it to C:\Program Files, as this requires administrator permissions and is not the correct user path.

5
Restart Excel and Test

Close Microsoft Excel completely and reopen it. Create a new blank workbook to verify that your predefined custom cell styles appear automatically.

Create a Default Workbook Template in the XLSTART Folder
Alternative Folder Path: If typing %appdata% does not work, you can manually navigate to C:\Users\<your-username>\AppData\Roaming\Microsoft\Excel\XLSTART after enabling 'Hidden items' in the File Explorer View tab.
Powerful Spreadsheet Tool

Easily Manage Custom Styles and Templates with WPS Spreadsheet

WPS Spreadsheet offers an intuitive interface to create, save, and manage custom workbook templates. It provides full compatibility with Excel formats and a highly efficient environment for your data formatting needs.

  1. 1. Launch WPS Spreadsheet: Open WPS Office and create a new blank spreadsheet.
  2. 2. Configure Custom Styles: Use the Home tab to adjust font formatting, number styles, and custom cell colors as needed.
  3. 3. Save as a WPS Template: Click Menu > Save As. Choose 'WPS Spreadsheet Template (*.ett)' or 'Excel Template (*.xltx)' and save it to your preferred template directory.
  4. 4. Apply to New Workbooks: Whenever you need to start a new file, select your custom template directly from the WPS Office 'New' tab to begin with all formatting ready.
Fully compatible with Microsoft Excel formats, including .xlsx, .xltx, and .csv.Intuitive cell styling features to quickly standardize your daily reports.Lightweight architecture ensuring fast launch speeds even with heavy templates.Free to use with a familiar interface, requiring no learning curve.
microsoft office alternative - wps office

Frequently Asked Questions

Why can't I find the %appdata% folder on my computer?

The %appdata% directory is a system folder that Windows hides by default. To find it easily, type '%appdata%' directly into the File Explorer address bar and press Enter. Alternatively, go to the 'View' tab in File Explorer and check the box for 'Hidden items'.

What happens if I name the template something other than Book.xltx?

If you name the file anything else (e.g., MyStyles.xltx), Excel will not recognize it as the default base for new blank workbooks. It must be named exactly 'Book.xltx' for standard files or 'Book.xltm' if it contains macros.

Will this default template affect existing workbooks?

No. Saving 'Book.xltx' in the XLSTART folder only dictates the layout and styles for brand new blank workbooks created via Ctrl+N or the 'Blank workbook' option. Existing files will retain their original formatting.