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

E

excelnut

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!
 
M

Myrna Larson

Maybe you can copy the table to a new range. There you can set up AutoFilter
to show only the non-zeroes.
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Hide Zero Subtotals - Excel 2007 4
Hiding blank cells within a Pivot Table 1
N/A in pivot table become 0 1
Pivot table grouping help 0
Conditional Formatting - Selective Cell Highlighting 5
Summing Problem In A Pivot Table 1
VB Script reference cells for in current table? 1

Top