Forum Discussion
slohombre
Sep 09, 2020Brass Contributor
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
Sort By
Staying on cell with blank in formula bar enter space instead of it. Refresh.
- JDMIDCopper Contributor
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.
- slohombreBrass Contributor
slohombre , you are welcome