Site icon ExcelNotes

How to Show Zero in Cells that Have Zero Value

When enter zero in the cell, Excel will show zero in the cell, but if the feature disappeared and you want it back, please follow the steps below:

Step 1: Click the "File" Tab from the ribbon;

Step 2: Click "Options" from the left navigation menu;

Step 3: Click "Advanced" from the left navigation menu in the dialog box;

Step 4: Check the box of "Show a zero in cells that have zero value" under the section of "Display options for this worksheet";

Step 5: Click "OK" at the bottom.

Exit mobile version