G’day All,
In this free downloadable Excel Pivot Table Cheat Sheet/Infographic, I show you how easy it is to create an Excel Pivot Table in 5 Speedy Steps…Enjoy and please comment below if you have any Excel or Pivot Table questions, I’m here to help you 🙂
*** Click on the image to enlarge or right click on the image to save image/target to your desktop ***
>>CLICK TO JOIN OUR FREE PIVOT TABLE TRAINING NOW <<
Hi,
Why is it that zero or blank appears in the slicer even though there is no space/blank or zero value in that particlar column in the table? i often click the filter in the slicer and uncheck the space/blank or zero. Thank you.
Hello Jose,
The Pivot Table hides any zero values automatically but the Slicer does not.
You can Right Click on the Slicer and select Slicer Settings > “uncheck” Hide items with no data.
Does this help?
Thanks,
John
John, I have posted about this in the G+ Excel Experts community; you can find the post here https://plus.google.com/+PeterBuyze/posts/7Lw8gybw3V6.
Thanks Peter!
