Showing zeros in Excel

Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them. We typically find that while building the spreadsheet we prefer to see all the numbers as not seeing a zero may lead to the accidentally overwriting of a formula or important input. Presenting though is a different matter.

You can set whether to display or hide zero’s in the Excel options tab. Click on the options button, choose the Advanced option and scroll down until you get to ‘Display options for this worksheet’ as shown below. You can then choose which sheet in the workbook you are wanting to change and either tick or untick the ‘Show a zero in cells that have zero value’

Show or do not show zeros in excel
Show or do not show zeros in excel


Ignore zeros in average