Office Settings & Configuration

Hide Zero Values by Default in New Excel Workbooks

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

Set up Excel so new workbooks hide zero values by default.

Hide Zero Values by Default in New Excel Workbooks
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.
Before you start

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.

Solution 1Recommended

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.

1
Create a workbook

Open Excel and create a blank workbook. Add or remove worksheets so the workbook has the sheets you want by default.

2
Hide zeros on each sheet

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.

3
Find the XLStart folder

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.

4
Save the default template

Select File > Save As, choose Excel Template (*.xltx), and save the workbook in XLStart with the file name Book.xltx.

5
Test a new workbook

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.

Save a Default Excel Workbook Template That Hides Zeros
Scope of the template: The template does not change existing workbooks. Sheets inserted later may use their own default settings, and some ways of creating a blank workbook may not use Book.xltx.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel XLSX filesWork with spreadsheet data in a familiar interfaceUse a free, lightweight office suiteMove compatible workbooks between Excel and WPS Spreadsheets
QA img-9

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.