Display Blank Cell when it contains Zero in Excel 2013

When a cell contains Zero as its value, it is still retained and is not removed by default in Excel. This behaviour can be easily modified by disabling a small feature or option in Excel 2013.

Display Blank Cell when it contains Zero in Excel 2013

Follow the below steps to display blank cell when it contains zero in Microsoft Excel 2013.

1. Launch Microsoft Excel 2013 and click File -> Options.

2. This will display the Excel Options Dialog. In the Excel Options Dialog , click “Advanced” in the left sidebar and then under the “Display options for this worksheet” group , uncheck/disable the option “Show a zero in cells that have zero value” and then click OK.

Display Blank Cell when it contains Zero in Excel 2013

3. This will make the cells that contain zero to blank.

Leave A Reply

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

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021