Show Blank Cells Containing Zero In Excel 2010

By default Excel 2010 doesn’t remove zero from cell if it contains  only a zero, however, you can easily change  this behavior from Excel Options dialog to show a blank cell in all cells which contain only zero.

To show blank cell instead of cell containing zero, on File menu, click Options.

677d1275638673-show-blank-cells-containing-zero-


It will open Excel Options dialog, from left sidebar, select Advanced and from main window, under Display Options for this worksheet, disable Show a zero in cells that have zero value option.

676d1275638672-show-blank-cells-containing-zero-

Now  you will see blank cells rather zeros placed in the cells.

Advertisement
  • Matthew Rees

    This only works if you want to blank all zeros. A more common case is to blank zeros in data entry fields but show zeroes in total fields and other formulae.

    • http://twitter.com/Llanirev Ferry

      True, but how would you make Excel do that?

  • jay

    what for 2007

  • TrueDat

    @matthew_rees:disqus No…it only blanks a cell that has zero as the ONLY value…if a cell has another value coupled with the zero like a 10, the work around mentioned in this article does not affect those cells.