Pivot tables - 'blank' label

[AS]

Hello,

I would like to get rid of 'blank' label that appears in some blank cells in
pivot tables. I just want it to appear blank. thank you.

 

[Jacob Skaria]

In the blank cell type a space character.

If this post helps click Yes

 

[AS]

Thank you. Where do i find the blank cell type setting? thank you

 

[David Biddulph]

What I think Jacob meant is go to the blank cell, and type a space into it.