Excel 2010:在数据透视中隐藏0值 [英] Excel 2010: Hide 0 values in Pivot

问题描述

对于数据为零的单元格，是否可以在数据透视表中隐藏或显示空白单元格?

Is there a way to hide or show a blank cell in a Pivot table for cells that compute to zero?

推荐答案

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

Use a number format to hide zero values in selected cells:

请按照以下步骤在选定的单元格中隐藏零值.如果这些单元格之一中的值更改为非零值，则该值的格式将类似于通用数字格式.

Follow this procedure to hide zero values in selected cells. If the value in one of these cells changes to a nonzero value, the format of the value will be similar to the general number format.

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

这篇关于Excel 2010:在数据透视中隐藏0值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！