have a pivot table with blank cells. people would like to have 0's in the
cells.
doable?
have a pivot table with blank cells. people would like to have 0's in the
cells.
doable?
yep.
right-click the table.
Select table options.
where you have for empty cells display nothing.
Put in a 0.
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
Mark wrote:
> have a pivot table with blank cells. people would like to have 0's in the
> cells.
> doable?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks