How To Show Items With No Data In PivotTables In Excel

When you filter data in a PivotTable, sometimes your rows or columns will disappear if there is no data. Here is an option that keeps those rows and columns visible.

You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.

PivotTable Basics can be found here!

PivotTable Timelines can be found here!

Happy Excelling!

Free Download!

Subscribe to Download Your FREE Copy of
"My 70+ Favorite Excel Keyboard Shortcuts" Today!


  1. Yes No PivotTable In #Excel | Excel Bytes - February 2, 2015

    […] You can find the post for “Show Items With No Data” here! […]

Leave a Reply