Tip 169 – Clean Up your Worksheets by Hiding Zero Values

If you have an Excel worksheet that contains many zero values which you don’t want to display, you can easily hide them. To do this, choose File > Options > Advanced and scroll to the Display options for this worksheet settings. Disable the Show a zero in cells that have zero value checkbox and click Ok. This change affects only the current worksheet.