When working with sheets containing many zeros, you can hide them for better readability of the data. Hidden zeros are displayed only in the formula bar and are not printed.
The current Hide zero values option applies separately to each worksheet.
Hide or show zero values
1.Right-click on the tab of the required sheet.
2.In the context menu, select one of the options:
•Hide zero values — to hide the zeros on the sheet.
•Display zero values — to show the hidden zeros again.