How to remove (blank) from pivot table layout

%3CLINGO-SUB%20id%3D%22lingo-sub-1649029%22%20slang%3D%22en-US%22%3EHow%20to%20remove%20(blank)%20from%20pivot%20table%20layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649029%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20morning%2C%20all.%20How%20can%20I%20remove%20the%20%22(blank)%22%20entry%20showing%20up%20in%20the%20Beds%20column%20of%20the%20pivot%20table.%20If%20there%20is%20no%20data%20in%20those%20cells%2C%20I'd%20like%20to%20be%20empty.%20Any%20help%20would%20be%20greatly%20appreciated.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(55).png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217322i5C1CD245CF0F4803%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Screenshot%20(55).png%22%20alt%3D%22Screenshot%20(55).png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1649029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1649116%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20(blank)%20from%20pivot%20table%20layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649116%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F676026%22%20target%3D%22_blank%22%3E%40slohombre%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStaying%20on%20cell%20with%20blank%20in%20formula%20bar%20enter%20space%20instead%20of%20it.%20Refresh.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1649299%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20remove%20(blank)%20from%20pivot%20table%20layout%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1649299%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYou%20are%20always%20a%20tremendous%20help.%20Many%20thanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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.Screenshot (55).png 

5 Replies

@slohombre 

Staying on cell with blank in formula bar enter space instead of it. Refresh.

@Sergei Baklan You are always a tremendous help. Many thanks!

 

Paul

 

@slohombre , you are welcome

@Sergei Baklan 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.

@JDMID 

You can't remove value here, but you may type <blank> instead of space.