How to Add Custom Excel Cell Styles to Every New Workbook
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.

- 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.
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.
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.
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.
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.
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.
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.
Close Microsoft Excel completely and reopen it. Create a new blank workbook to verify that your predefined custom cell styles appear automatically.

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. Launch WPS Spreadsheet: Open WPS Office and create a new blank spreadsheet.
- 2. Configure Custom Styles: Use the Home tab to adjust font formatting, number styles, and custom cell colors as needed.
- 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. 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.

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.




