Display or hide all zero values on a worksheet



This is a common question we get asked from a lot of Excel users, how do you not display a zero in a cell.  It very simple to turn off a zero value by following the directions below.

  1. Click the Microsoft Office Button Button image, click Excel Options, and then click the Advanced category.
  1. Under Display options for this worksheet, select a worksheet, and then do one of the following:
    • To display zero (0) values in cells, select the Show a zero in cells that have zero value check box.
    • To display zero values as blank cells, clear the Show a zero in cells that have zero value check box.

 

Microsoft Excel ,

Leave a Reply

Your email address will not be published. Required fields are marked *