Hide Zero Values by Default in New Excel Workbooks
Question details
Set up Excel so new workbooks hide zero values by default.

- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- The user wants new Excel workbooks to start with zero values hidden without changing the setting each time.
- Observed behavior
- The zero-display setting is configured for individual worksheets and does not automatically apply to every new workbook.
Open Excel and decide how many worksheets you want in your default workbook. You will need to apply the zero-display setting to each worksheet included in the template.
Save a Default Excel Workbook Template That Hides Zeros
Use a template in Excel's XLStart folder to apply the setting to worksheets in new workbooks created from the default template.
Open Excel and create a blank workbook. Add or remove worksheets so the workbook has the sheets you want by default.
Go to File > Options > Advanced. Under Display options for this worksheet, select a worksheet and clear Show a zero in cells that have zero value. Repeat for each worksheet, then select OK.
Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations and look for the XLStart path. On Windows, you can also enter %appdata%\Microsoft\Excel\XLSTART in File Explorer's address bar.
Select File > Save As, choose Excel Template (*.xltx), and save the workbook in XLStart with the file name Book.xltx.
Restart Excel and press Ctrl+N to create a workbook. Enter 0 in a cell on each template sheet to check that the value is hidden.

Work With Spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files in WPS Spreadsheets to continue working with an easy-to-use interface and make migration straightforward.

Frequently Asked Questions
Does hiding zeros remove the values from cells?
No. Clearing Show a zero in cells that have zero value under File > Options > Advanced changes the display; the zero values remain in the cells and can still be used in formulas.
Where is the XLStart folder in Windows 10?
In File Explorer, enter %appdata%\Microsoft\Excel\XLSTART in the address bar. You can also check Excel's listed locations under File > Options > Trust Center > Trust Center Settings > Trusted Locations.
Will the template hide zeros in my existing workbooks?
No. For an existing workbook, open File > Options > Advanced and clear Show a zero in cells that have zero value for each worksheet you want to change.
Why are zeros visible on a worksheet I added later?
The Book.xltx template controls the worksheets included in a new workbook. For an added sheet, select it under File > Options > Advanced > Display options for this worksheet and clear the zero-display option.
How can I check whether Excel is using my template?
Restart Excel, press Ctrl+N, and enter 0 in a cell on a template sheet. If it appears, check that the file is named Book.xltx and is saved in the XLStart folder.




