have a pivot table with blank cells. people would like to have 0's in the cells. doable?
M Mark Feb 4, 2005 #1 have a pivot table with blank cells. people would like to have 0's in the cells. doable?
D Debra Dalgleish Feb 5, 2005 #2 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
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
