Hiding Zero Values in a Pivot Table - MS Excel 2007


T

Taveras

Does anyone know how to hide zero values in a pivot table in MS Excel 2007.
It used to be fairly simple in 2003 (just unchecking blank values or
something), but there doesn't appear to be an option for this in 2007. Does
anyone know how to do this? Thanks.
 
Ad

Advertisements

R

Roger Govier

Hi

Press the round Office button>Excel Options>Advanced>Display options for
this worksheet>un-check Show a Zero in cells that have zero values
This applies to the whole sheet, not just the PT.

You are perhaps confusing this with the new location for
In the PT itself, right click on any cell>Pivot Table Options>Layout &
Format> there is an options to check For Empty cell Show > decide on
character to be used.
 
T

Taveras

Hi -

Following those steps just makes the zero's come out as dashes.

What I'd like to do is remove or hide the entire rows that have zero values
in pivot tables. I guess maybe it wasn't clear from the post.

Thanks.
 
R

Roger Govier

Hi

You must have you data formatted in a special way. Mine just shows blank
cells.
Try
right clicking on a field>Field Settings>Layout & Print>remove check mark
from Show items with no data.
 
Ad

Advertisements

S

sergio.siles

Where you able to fix that thing Taveras? Im having the same problem
and I havent found a good solutions
 

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

Top