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

Display empty value instead of zero in Microsoft Excel

Display empty value instead of zero in Excel 2010 and Excel 2013

Microsoft Excel 2010 and 2013 allows users to display the empty values instead of displaying zeros. For example if you have got the following list of data where instead of displaying zero for Product 4 you want excel to display empty value then you can Excel Advanced options for changing this behaviour.

image

Click File menu and then Options link.

In the Excel Options window, navigate to Advanced Options.

image

Under Advanced Options screen, scroll down to Display Options for this worksheet section.

image

To hide the zero values, un tick the checkbox with label as Show a zero in cells that have zero value. The Example data shown will now be displayed as below i.e only empty value will be displayed instead of zero.

image

3 comments… add one
  • very useful tip.

  • It works fine but i need to change this option for every single worksheet.
    Is there a way to make this the default setting in Excel?

Leave a Comment

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