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

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

"Jacob Skaria" wrote:

In the blank cell type a space character.

If this post helps click Yes
---------------
Jacob Skaria


"AS" wrote:

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.