Hide zero values in a PivotTable report
How do I hide zero values in a PivotTable report. It didn't work what was
suggested under the Office site. |
Hide zero values in a PivotTable report
Was that suggestion this one?
Hide zero values in a PivotTable report Click the report. On the PivotTable toolbar, click PivotTable, and then click Table Options. Do one or more of the following: Change error display Select the For error values, show check box under Format options. In the box, type the value that you want to display instead of errors. To display errors as blank cells, delete any characters in the box. Change empty cell display Select the For empty cells, show check box. In the box, type the value that you want to display in empty cells. To display blank cells, delete any characters in the box. To display zeros, clear the check box. What part "did not work"? Gord Dibben MS Excel MVP On Mon, 25 Sep 2006 11:15:02 -0700, KC wrote: How do I hide zero values in a PivotTable report. It didn't work what was suggested under the Office site. |
All times are GMT +1. The time now is 04:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com