Content
# Display zeros in Excel
Hide or display all zero values on a worksheet
Click File > Options > Advanced.
Under Display options for this worksheet, select a worksheet, and then do one of the following:
To display zero (0) values in cells, check the Show a zero in cells that have zero value check box.