Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot tables show zeros
I have a great povit table however, I would like to have a 0 (Zero) to show
were there is no value. |
#2
|
|||
|
|||
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 sueanne wrote: I have a great povit table however, I would like to have a 0 (Zero) to show were there is no value. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Povit tables I mean. I know I have do this in the past Looking in the format
area. "sueanne" wrote: I have a great povit table however, I would like to have a 0 (Zero) to show were there is no value. |
#4
|
|||
|
|||
Thank you dear person.
I can go home. "Debra Dalgleish" wrote: 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 sueanne wrote: I have a great povit table however, I would like to have a 0 (Zero) to show were there is no value. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables show zeros
Debra
Would this then apply to all spreadsheets or only the one that was open when this was done? Steve "Debra Dalgleish" wrote: 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 sueanne wrote: I have a great povit table however, I would like to have a 0 (Zero) to show were there is no value. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot tables show zeros
Steve, the option is set for that PivotTable only. If you have another
PivotTable, you need to set up that option again. -- Some day I''''ll be the most powerful Jedi ever. "Steve" wrote: Debra Would this then apply to all spreadsheets or only the one that was open when this was done? Steve "Debra Dalgleish" wrote: 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 sueanne wrote: I have a great povit table however, I would like to have a 0 (Zero) to show were there is no value. -- 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 | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables: Unable to Group and Show Detail | Excel Discussion (Misc queries) | |||
Pivot Tables - Variance and % Variance fields | Excel Discussion (Misc queries) |