1. Home
  2. MS Office

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.

Leave a comment