View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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