How does an Excel value of 0 automatically hide?
1, use the condition pattern. Click Column B, select all column B (and, of course, b2:b1000), pattern-condition pattern-cell value-equals-0, so you set the conditions, which means that when equals 0 o'clock, what's going on? Again (right) pattern-font-color-click on the white in the right, concluded. This way, when any cell value in column B is 0 o'clock, it becomes white and invisible. The requirement cell is white without a fill color.
2. Formula method: Add an If function on the basis of the original formula. The main meaning of grammar is: =if (the original formula = 0, "", the original formula) explanation: When the formula operation value is 0 o'clock, appears the space, does not show the accounting value for 0 o'clock.