hide zeros on pivot table

  • Thread starter Thread starter Marcelo
  • Start date Start date
Click the down arrow on the Row or Column, and uncheck zero. You could also
try double-clicking one of the pivots and choose Subtotals > None > OK.

Hope that helps.


Regards,
Ryan---
 
I don't know if you can hide zeros just for the pivot table, but if you
select Tools >> Options >> View and uncheck Zero values, they will be hidden
everywhere on that sheet (including the pivot table).

Hope this helps,

Hutch
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding blank cells within a Pivot Table 1
N/A in pivot table become 0 1
Summing Problem In A Pivot Table 1
Pivot table field list missing 5
grouping dates in a pivot table 1
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot table Help Excel 2007 1
Hide part of Pivot Table 1

Back
Top