| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
display / print 0's in pivot table cells
have a pivot table with blank cells. people would like to have 0's in the
cells. doable? |
|
#2
|
|||
|
|||
|
Select a cell in the pivot table
On the PivotTable toolbar, choose PivotTableTable 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
| Counting blank cells in Pivot Table | Excel Worksheet Functions | |||
| Password protect cells PivotTable & allow the Pivot Table to refre | Excel Worksheet Functions | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
| Pivot table, how do you exclude counting cells with formulas as a | Excel Worksheet Functions | |||
Hybrid Mode
