Pivot Table (blank) Cells

  • Thread starter Thread starter koala824 at Comcast
  • Start date Start date
K

koala824 at Comcast

Can I remove the '(blank)' entry that appears in pivot table cells that have
no contents? Thanks
 
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.
 
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
 
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
Click to expand...
 
Back
Top