display / print 0's in pivot table cells

G

Guest

have a pivot table with blank cells. people would like to have 0's in the
cells.
doable?
 
D

Debra Dalgleish

Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTable>Table Options
Check the box 'For empty cells, show'
In the text box, type a zero
Click OK
 

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

Pivot Table 2
Adding to an existing Pivot Table 7
Refreshing Pivot Table on a protected spreadsheet tab 1
Pivot Table 1
Pivot Table ... Suppress "0" Values? 2
Pivot table bottom ten filter with conditions 2
display all row fields in pivot table 1
Using merge cells in worksheet for Pivot Table 1

Top