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.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...
How to protect all worksheets at once in Excel using VBA ?
Assume that you have a worksheet and you wish to protect all of the worksheets with a password at on...