Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

hide zeros on pivot table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Marcelo - 12 Mar 2008 14:12 GMT
how to do it ?

thanks
Signature

regards from Brazil
Thanks in advance for your feedback.
Marcelo

ryguy7272 - 12 Mar 2008 20:15 GMT
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---

Signature

RyGuy

> how to do it ?
>
> thanks
Tom Hutchins - 12 Mar 2008 20:19 GMT
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

> how to do it ?
>
> thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.