Tip Printed from ExcelTip.com

---

Hiding the Display of Zero Values


To hide zero value in specific cells:

The third section in the number custom formatting (after the second ;) returns the formatting for a zero value. To hide the zero value, erase the # and 0 symbols in this section. The formatting will now display an empty cell.

Example:
#,##0_;[Red](#,##0);;

To hide zero values in a sheet:

1. From the Tools menu, select Options, and then select the View tab.
2. Deselect the Zero values checkbox and click OK.
To hide zero values in all cells in the entire workbook:
1. From the sheet tab's shortcut menu, select Select All Sheets.
2. Follow the steps in the previous procedure.