Help!

surpress 0 on pivot tables
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map RSS
Next:  Client Access Download To Excel - Excel Format?  
Author Message
Jelinek
External


Since: Mar 20, 2006
Posts: 8
PostPosted: Fri Jun 15, 2007 3:46 am    Post subject: surpress 0 on pivot tables
Archived from groups: microsoft>public>excel>datamap (more info?)
Is there away to surpess 0 on pivot tables?
Back to top
ShaneDevenshire
External


Since: May 19, 2006
Posts: 441
PostPosted: Fri Jun 15, 2007 9:40 am    Post subject: RE: surpress 0 on pivot tables [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi,

Select the pivot table and choose PivotTable, Table Options, check For empty
cells, show and then leave the box after it empty.

Or turn off the 0's for the entire sheet using Tools, Options, View, and
uncheck Zero Values.
--
Cheers,
Shane Devenshire


"Jelinek" wrote:

> Is there away to surpess 0 on pivot tables?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Data Map All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum