pivot tables show zeros

G

Guest

I have a great povit table however, I would like to have a 0 (Zero) to show
were there is no value.
 
D

Debra Dalgleish

Right-click on a cell in the pivot table
Choose Table Options
Check the box for 'For empty cells show'
In the box, type a zero
Click OK
 
G

Guest

Povit tables I mean. I know I have do this in the past Looking in the format
area.
 
G

Guest

Thank you dear person.
I can go home.

Debra Dalgleish said:
Right-click on a cell in the pivot table
Choose Table Options
Check the box for 'For empty cells show'
In the box, type a zero
Click OK
Click to expand...
 
G

Guest

Debra
Would this then apply to all spreadsheets or only the one that was open when
this was done?
Steve
 
S

Skywalker

Steve, the option is set for that PivotTable only. If you have another
PivotTable, you need to set up that option again.
 

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

povit table colum head 1
Surpressing rows and columns with zero values in a pivot table 1
Exclude zeros from pivot table averages 1
Pivot Table Shows Only Zeros 3
pivot table - shows zero when should not be 1
Need the grand total pivot table filtered worksheet? 1
pivot table value filter 1
Excel 2007 Pivot Tables - do not display zero values 2

Top