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.
