Do not display zero values in excel?
Click on Options. In the Excel Options dialog box that opens, click on the 'Advanced' option in the left pane. Scroll down to the section that says 'Display option for this worksheet', and select the worksheet in which you want to hide the zeros. Uncheck the 'Show a zero in cells that have zero value' option.
How do I ignore a cell with zero value in Excel?
1. Click the File tab, choose Options in the left pane and then click Advanced in the left pane. 2. In the Display Options For This Worksheet section, uncheck Show A Zero In Cells That Have Zero Value (Figure A).