Removing the word "blank" in Pivot Table labels

This video describes two workaround techniques of replacing the word "blank" in Pivot Table labels with an actual blank. Both methods are workarounds.

[@SaifAHadi]

You make it simple and easy. Thank you Sir.

[@eddiepaterson1583]

If you go back to the Manage Rules of the Conditional formatting, you can apply this rule to the 'Worksheet' instead of just the 'selection'. ALSO, you can format the 'color' of the font to 'white' to make it effectively disappear OR to say, a very light blue so you CAN see it but barely.

[@earic2499]

Thank you very much good sir

[@cynthiaperkins9943]

"Space" thanks a ton!!!!! :)

[@onlg8]

Space is working excellent thanks a lot

[@neilgore]

super .. space worked wonderfully

[@michaelowen8]

This is IT. I have been searching on google for the solution. Most of them referred to the Options on PivoTable menu which you can choose "For empty cells show: ", but it didn't work. Your solution, however, worked like magic. Thank you!

[@cacharmidoshi2774]

Thanks for Sharing knowledge

[@daniellesetsuko]

Thank you for this!

[@sfodon11]

Very helpful. Thank you!

[@adil6464]

Thank you. The video was very informative

[@Avancerinc]

Thanks very much!

[@BBB-fe9up]

Thanks!!

[@Sarsssour]

is there a way to simply have a blank cell instead? i try to delete but it won't allow me

[@willow-lane]

useful, thank you

[@Avancerinc]

Thanks for your feedback!

[@tallswar]

very nice, kindly keep on sir

[@Avancerinc]

Thanks for the feedback

[@bmettle8246]

Thank you for this. Very helpful. Would you also be able to do a video on how you created the pivot table?

[@Avancerinc]

Great suggestion - I do videos on common tasks that people have trouble with, so will try and include the making of a Pivot Table into a future one.

[@bmettle8246]

@@Avancerinc Thank you, I look forward to it; and thanks again for your help. You've probably saved countless jobs without even knowing! 😅

[@Tat-cx1lr]

Merci

[@mjfernandezmoreno]

thanks!!!!!!!!