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

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...
How to copy multiple sheets in Excel?
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Micr...