Excel 2010:在数据透视中隐藏0值

本文介绍了Excel 2010:在数据透视中隐藏0值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

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

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.

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