POWER USER PRO TIP

Pivot Errors & Empty Rows

I’ll be honest, 99% of you will never need to use this next tip (but for the 1% of you who will, this is a lifesaver). While PivotTables will hide rows containing no data by default, you have the option to not only force them to be displayed, but also to customize how they appear.

In this tip, we’ll modify our IMDb Movie Database pivot to display gross revenue values by country and genre — even for cases where no revenue was generated.

COMMON USE CASES:

  • Displaying all possible items within the pivot to create a consistent layout or template
  • Reformatting blanks or errors to clean up user-facing reports or dashboards

Interested in learning more?

Sign up for the Pro Tips for Power Users online course today to unlock exclusive project files and resources.

The full course includes PDF eBooks and Excel project files containing every demo & dataset covered in the course — ranked by difficulty (1-5 stars), organized by category, and hyperlinked for quick access.

It’s time to start working smarter, not harder. If you’re looking to maximize efficiency, supercharge productivity, and become an Excel POWER USER, this is the course for you.

Exclusive Offer – Full Course Access

Excel Pro Tips for Power Users

Full Price $199    Today’s Price 75% OFF!

75+ Excel tips to help you work smarter, boost productivity and become a certified power user. You’ll receive lifetime access to:

  • 10+ hours of high-quality video content

  • Downloadable eBook & Excel project files (with solutions)

  • Course quizzes to test your knowledge

  • 1-on-1 expert support

  • 100% satisfaction guarantee (no questions asked)

UNLOCK THE FULL COURSE