surpress 0 on pivot tables

Your Complete Resource Center for "The Best" in Shareware, Computing Tips and Support, Windows Industry News... and much more!

Home

FAQ

Profile

Private Messages

surpress 0 on pivot tables

Home -> Office -> Data Map

Next: importing a Yahoo csv file back to yahoo address ..

Author

Message

Jelinek

External

Since: Mar 20, 2006
Posts: 1

(Msg. 1) Posted: 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?

Login to vote

ShaneDevenshire

External

Since: May 19, 2006
Posts: 2098

(Msg. 2) Posted: 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?

Login to vote

Display posts from previous:

	Home -> Office -> 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

Categories:
Windows XP
Windows Vista
Windows Other
Office
Office Other
Security

free stats