In excel and a pivot table - how can I stop it displaying (blank).

M

Mansel

Hi there, I'm learning to use pivot tables. How can I stop the table listing
(blank) in certain cells?

I want to keep the data it relates to but would rather see that cell empty

Regards

Mansel
 
B

Bob Umlas, Excel MVP

In step 3 of the pivot table wizard, you can click the Options button, and in
this dialog there's a checkbox "For Empty Cells, show" and you can fill in
something (or leave blank)
HTH
Bob Umlas
Excel MVP
 
Top