To hide zero values in a sheet:
1. Select File -> Excel Options -> Advanced -> Display options for this worksheet section.
2. Deselect the checkbox in Show a zero in cells that have zero value.
To hide zero values in all cells in the entire workbook:
1. From the sheet tab shortcut menu, select Select All Sheets.
2. Follow the steps of previous procedure.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.