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.

image

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.



Meet the Author

Ravi Shankar

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

0 comments… add one

Leave a Comment

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