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 appreciat...
slohombre you could also apply Conditional Formatting to the entire sheet to set the text colour of all cells equal to "(Blank)" to white.
kimingi , that affects performance dramatically