Skip Navigation Links

INFO: Hide zeros (0) in a worksheet

Posted on 03.15.11


1. Click the Microsoft Office Button.
2. Click Excel Options, Advanced.
3. Under Display options for this worksheet section: uncheck Show a zero in cells that
    have zero value
.
4. Click OK.
 
Reverse the steps to display the zeros.