pivot-table - Excel 2010 : Hide 0 values in Pivot

Question

有没有办法在数据透视表中为计算为零的单元格隐藏或显示空白单元格？

Answer 1

使用数字格式隐藏所选单元格中的零值:

按照此过程隐藏所选单元格中的零值。如果其中一个单元格中的值更改为非零值，则该值的格式将类似于一般数字格式。

1.Select the cells that contain the zero (0) values that you want to hide.
2.On the Format menu, click Cells, and then click the Number tab.
3.In the Category list, click Custom.
4.In the Type box, type 0;-0;;@

注释

- The hidden values appear only in the formula bar — or in the cell if you edit 
    within the cell — and are not printed.
- To display hidden values again, select the cells, click the Cells command on 
    the Format menu, and then click the Number tab. In the Category list, 
    click General to apply the default number format. To redisplay a date or 
    a time, select the appropriate date or time format on the Number tab.

http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP005199879.aspx