Results 1 to 9 of 9

hide blank cell pivot table

Threaded View

verisme hide blank cell pivot table 02-20-2010, 10:13 AM
Palmetto Re: pivot table 02-20-2010, 02:16 PM
royUK Re: pivot table 02-20-2010, 02:53 PM
verisme Re: hide blank cell pivot... 02-20-2010, 10:27 PM
DonkeyOte Re: hide blank cell pivot... 02-21-2010, 05:06 AM
royUK Re: hide blank cell pivot... 02-21-2010, 04:57 AM
royUK Re: hide blank cell pivot... 02-21-2010, 05:18 AM
verisme Re: hide blank cell pivot... 02-21-2010, 09:26 AM
royUK Re: hide blank cell pivot... 02-21-2010, 09:40 AM
  1. #1
    Registered User
    Join Date
    12-26-2009
    Location
    everywhere but nowhere
    MS-Off Ver
    Excel 2003
    Posts
    15

    hide blank cell pivot table

    hi,i've got this problem, i'm using pivot table and i want to erase the blank cell that come out with pivot table and replace it with number 0 or -, how can i do that ? i've be try to do this by go to the table option and in the empty cells check list i've put 0 or - but the pivot table still come out "blank",
    Attached Files Attached Files
    Last edited by verisme; 02-21-2010 at 09:25 AM. Reason: changing title

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1