If you have formulas or functions in your spreadsheet that evaluate to zero, all those zeros can make your worksheet unsightly and messy, especially if you have a lot of zeros. Luckily, Excel has an option that allows you to hide zeros, giving your spreadsheet a more professional and polished look. This can also help you to find and evaluate cells that contain non-zero values.
To Hide Zeros in Excel
- Click the File tab on the Ribbon.
- Click Options.
- In the left pane, click the Advanced category.
- Scroll down until you see Display Options for this Worksheet.
- Click the checkbox next to Show a zero in cells that have zero value to clear it.
- Click OK.