How to display blank for zero value in Excel 2016 & 2013

Excel 2013 allows user to display blank value instead of zero value for any expression. This is useful when you want the result value for any formula to be left blank instead of displaying zero.

Step 1: Click File menu, select Options from the menu list.

Step 2: In the Options window, click the Advanced tab.

Step 3: Scroll down the Advanced tab until you see the Display options for this worksheet.


Step 4: Un mark the check box with caption as “Show a zero in cell that have zero value”.

Step 5: Click OK button in the Options screen to confirm and save the changes.

In Category: Excel 2013, Excel 2016, Office 2013

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.