Forum Discussion
How to remove (blank) from pivot table layout
Good morning, all. How can I remove the "(blank)" entry showing up in the Beds column of the pivot table. If there is no data in those cells, I'd like to be empty. Any help would be greatly appreciated.
6 Replies
Staying on cell with blank in formula bar enter space instead of it. Refresh.
SergeiBaklan Okay, now how do I undo that? I can't edit the cell and delete the space, and it hasn't modified my source data in any way.
You can't remove value here, but you may type <blank> instead of space.
slohombre , you are welcome
