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.


Click File menu and then Options link.

In the Excel Options window, navigate to Advanced Options.


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


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.


In Category: Excel 2010, Office 2010

Ravi Shankar

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

Show 3 Comments
  • Anand August 16, 2011, 8:43 am

    very useful tip.

  • Rob August 16, 2011, 1:53 pm

    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.