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

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

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

"Mansel" wrote:

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