Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide zeros on pivot table
how to do it ?
thanks -- regards from Brazil Thanks in advance for your feedback. Marcelo |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide zeros on pivot table
Click the down arrow on the Row or Column, and uncheck zero. You could also
try double-clicking one of the pivots and choose Subtotals None OK. Hope that helps. Regards, Ryan--- -- RyGuy "Marcelo" wrote: how to do it ? thanks -- regards from Brazil Thanks in advance for your feedback. Marcelo |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hide zeros on pivot table
I don't know if you can hide zeros just for the pivot table, but if you
select Tools Options View and uncheck Zero values, they will be hidden everywhere on that sheet (including the pivot table). Hope this helps, Hutch "Marcelo" wrote: how to do it ? thanks -- regards from Brazil Thanks in advance for your feedback. Marcelo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress Zeros in a Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table Suppression of Zeros | Charts and Charting in Excel | |||
Data in my pivot table changes to zeros | Excel Discussion (Misc queries) | |||
Pivot table hidding zeros in sum of amount | Excel Discussion (Misc queries) | |||
Pivot table hidding zeros in sum of amount | Excel Discussion (Misc queries) |