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.


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.


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

  • 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.

    • 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.

    • Chadwick

      You misunderstand. When Matthew Rees says he wants he wants to show zeros in the total column, he means he wants to show “0” if the total is zero.
      The tip blanks out all zeros in the sheet. Matthew’s point is that sometimes you need to blank out zeros in one part of the sheet, but keep them visible in another.