Hide zero cells in pivot table. I don't want the cell to appear .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working with pivot tables. Much of my data totals ZERO, I do not want
the cells that contain zero to show up at all (not 0.00 or - or blank) it
makes my report too long. I end up having to hide all the cells individually.
any help would be great!
thanks!
 
Maybe you can copy the table to a new range. There you can set up AutoFilter
to show only the non-zeroes.
 
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
Summing Problem In A Pivot Table 1
Pivot table NOT showing zero value calculations 2
N/A in pivot table become 0 1
Blank Cells vs. Zero Values 2
Pivot table field list missing 5
PIVOT TABLE WITH BLANK CELLS 1
vlookup in pivot table 1

Back
Top