Pivot Table (blank) Cells

  • Thread starter koala824 at Comcast
  • Start date
K

koala824 at Comcast

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

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.
 
K

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
 
D

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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table display 1
Pivot Table selection that will allow Grouped fields to show up ineach cell 1
Export Pivot table 1
copy an intial cells contents into the next series of blank cells ina column 2
Pivot Table Help! 1
Make a pivot table from an existing pivot table 2
Pivot table report invalid 0
Excel VBA For excel 0

Top