How to Stop Showing Zeroes in Cells in Excel 2010

Formulas in Microsoft Excel 2010 are incredibly useful. You can use them to makes all sorts of calculations, and you can even copy and paste formulas into other cells, and the formulas will adjust to use values that are relative to the cell in which the formula has been pasted. Excel will then display the value that results from executing your formula, allowing you to see the answer. By default, this action will display the number “0” if that is the result of an executed formula. While this is perfectly valid in many situations, some users might find that they do not want to display anything in a cell if the value is zero. Fortunately this is a setting that can be adjusted within the program, so it is possible to stop showing zeroes in cells in Excel 2010.


Hide Zeroes in Excel 2010


This action is not restricted to formulas, however. By making this adjustment in Excel, you will effectively stop Excel from displaying any cell value that is “0”. This can be very helpful if you are attempting to make a spreadsheet look a certain way, or if there are so many zero values in the worksheet that it becomes distracting.


Step 1: Click the File tab at the top of the window, then click Options at the bottom of the column on the left.

excel options from file tab


Step 2: Click the Advanced tab at the left side of the Excel Options window.

advanced tab on options menu


Step 3: Scroll to the Display options for this worksheet section, then click the box to the left of Show a zero in cells that have zero value to remove the check mark.

hide zeroes in excel 2010


Step 4: Click the OK button at the bottom of the window.


Note that this action will only stop displaying values of zero for the sheet that is currently active in your workbook. If you want to make this change for other sheets as well, then you will need to click the drop-down menu to the right of Display options for this worksheet, then choose either a different sheet or the entire workbook. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.