How to prevent blank cells from showing in a pivot table

One of my viewers asked me how to prevent "blank cells/" from showing in a pivot table. This is a common request. Frequently, when you send a pivot table to a client or colleague who is unfamiliar with pivot tables, they will wonder why these "blank cells" appear.

Watch as I show you how to fix this problem. You'll also learn how to "drill down" to see the details behind any pivot table subtotal. Additionally, I show you a great keyboard shortcut for quickly applying and removing filters in a structured data set.

I invite you to visit my secure online shopping site – http://shop.thecompanyrocks.com – to view all the video training resources I offer.

Danny Roches
The company is great

Please take the opportunity to connect and share this video with your friends and family if you find it useful.