|  

» Hiding the Display of Zero Values

To hide zero value in specific cells:

The third section in the number custom formatting (after the second ;) returns the formatting for a zero value. To hide the zero value, erase the # and 0 symbols in this section. The formatting will now display an empty cell.

Example:
#,##0_;[Red](#,##0);;

To hide zero values in a sheet:

1. From the Tools menu, select Options, and then select the View tab.
2. Deselect the Zero values checkbox and click OK.
To hide zero values in all cells in the entire workbook:
1. From the sheet tab's shortcut menu, select Select All Sheets.
2. Follow the steps in the previous procedure.
Screenshot // Hiding the Display of Zero Values
Hiding the Display of Zero Values

Rate This Tip
12 34 5
Rating: 3.77     Views: 70567
how to leave a formatted cell blank
Jeremy  Posted on: 31-12-1969
I have a spreadsheet with multiple columns, specifically I am dealing with species of plants. The last column in the sheet gives the overall % each species occupies out of 100%. How do I leave the cells formatted and prevent 0% from showing up. The table is too confusing with all the 0%'s and it is not necessary for me to show 0%. Thanks for your time.
Name
Comment Title
Comments