Pivot Table (blank) Cells

[koala824 at Comcast]

Can I remove the '(blank)' entry that appears in pivot table cells that have
no contents? Thanks

 

[Dave Peterson]

Select one of the cells with (blank) in it.

Hit the space bar and hit enter.

This is really replacing the (blank) with a single space character.

 

[koala824 at Comcast]

Pretty slick. Works great, even if I cannot follow the programming logic of
it all. My mindset never considered actually editing the contents of a pivot
table cell. Thanks for the quick solution.
Ted Pierce

 

[Dave Peterson]

I think this comes as a surprise to every user!

Pretty slick. Works great, even if I cannot follow the programming logic of
it all. My mindset never considered actually editing the contents of a pivot
table cell. Thanks for the quick solution.
Ted Pierce