'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Set the Default Number Format for New Excel Workbooks
Question details
The user wants to automatically apply a specific number format to all new Excel workbooks without having to format cells manually each time.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Creating a new workbook and needing a specific default number formatting style instantly applied.
- Observed behavior
- By default, Excel uses a standard general number formatting, requiring users to manually select and format cells for their preferred styles.
Ensure you have your computer's hidden files and folders visible in your file explorer, as the system-level Excel startup folders are usually hidden by default.
Create a Custom Excel Template in the XLStart Folder
Save a pre-formatted blank workbook into Excel's startup folder so every new file automatically uses your desired number format.
Excel uses the XLStart folder to determine the default settings of any new workbook you create. By placing a customized template file here, you can dictate the default formatting.
Launch Excel and open a completely blank workbook.
Select all cells in the worksheet by clicking the triangle in the top-left corner (or pressing Ctrl+A), then right-click and choose 'Format Cells' to apply your preferred default number format.
Navigate to File > Save As. In the file type dropdown menu, select 'Excel Template (*.xltx)'.
Save the file to your XLStart directory, which is typically located at C:\Users\[YourUsername]\AppData\Roaming\Microsoft\Excel\XLSTART.
Name the file exactly 'Book.xltx' and click Save. Restart Excel to see the changes.
Modify System Regional Settings
If your desired number format is based on regional preferences like currency symbols or date formatting, changing your operating system's settings will apply it across Excel.
Specify an Alternative Startup Folder
Direct Excel to use a specific, easily accessible folder for loading your customized startup templates instead of digging for the hidden XLStart folder.
Looking for an Easier Way to Manage Spreadsheets? Try WPS Office
WPS Office is a free, lightweight, and user-friendly alternative to Microsoft Office. It offers seamless format compatibility, a familiar interface, and excellent spreadsheet tools without the hassle of complex folder configurations.
- 1. Download WPS Office: Visit the official WPS website and click the free download button for your operating system.
- 2. Install the Software: Run the installer file and follow the quick on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing Excel workbooks instantly with flawless formatting compatibility.
Frequently Asked Questions
Can I apply conditional formatting to a default template?
Yes, you can set up conditional formatting rules in your blank workbook before saving it as a 'Book.xltx' template in the XLStart folder. Every new workbook will then include those rules by default.
Why is my XLStart folder empty or missing?
The XLStart folder is located in the AppData directory, which is hidden by default in Windows. You must enable 'Show hidden files, folders, and drives' in your Windows File Explorer View options to locate it.
Will changing the default number format affect existing Excel files?
No, modifying the default template or system startup folder only applies to entirely new workbooks you create. Your existing Excel files will retain their original formatting.
Can I have multiple default templates?
Excel only uses the specific 'Book.xltx' file in the XLStart folder for the default blank workbook behavior. However, you can save other customized templates in your Personal Templates folder and select them manually via File > New.
