Excel Guides

Turning Off Display of Zeros for All Worksheets in Excel

To turn off the display of zeros for all worksheets in Excel, follow these steps:

  1. Open Microsoft Excel.
  2. Click the File tab, and then click Options.
  3. In the Excel Options dialog box, click Advanced, and then under Display options for this workbook, clear the Show a zero in cells that have zero value check box.
  4. Click OK. The option is applied to all worksheets in the workbook.


  • To apply this change to only selected worksheets, repeat steps 1 through 3 for each worksheet.

Tip: If you want to quickly find cells that contain zeros, you can use the Go To command (on the Home tab, in the Editing group) to select all cells that contain zeros. For more information about how to use Go To, see Find data in your worksheet by using Go To.

Move beyond 


Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.