Display or hide zero values

To display or hide zero values in Excel, you have a few ways to do it depending on your goal:

✅ Method 1: Hide Zeros Using Excel Options (For Entire Sheet)

1. Go to File → Options.
2. Click Advanced on the left.
3. Scroll down to the Display options for this worksheet section.
4. Uncheck the box for “Show a zero in cells that have zero value”.
5. Click OK.

🔁 This hides all zero values in the selected worksheet (they will still exist, just not be displayed).

✅ Method 2: Use a Custom Number Format (Specific Range or Cells)

1. Select the cells or range.
2. Right-click → Format Cells → Go to the Number tab.
3. Click Custom.
4. In the Type box, enter:

   0;-0;;@
   

   • This format:
     • Shows positive numbers (0)
     • Shows negative numbers (-0)
     • Hides zeros
     • Displays text normally

🧠 Use this when you want to hide zero values only in specific cells, not the entire sheet.

✅ Method 3: Use a Formula to Hide Zeros

If you’re using formulas, you can modify them like this:

=IF(A1=0, "", A1)

🔁 This formula will return a blank cell if the value is 0.

👀 Want to Show Zeros Again?

• Undo any custom formatting or re-check “Show a zero in cells that have zero value” in Excel Options.