Download free ebooks – Windows 8, Mac OS X, MSOffice, Keynote, Nexus etc.

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.

0 comments… add one

Leave a Comment

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