How to Hide #DIV/0! from Excel Pivot Tables

Have a bunch of ugly #DIV/0! errors cluttering up your masterfully created PivotTable?

Here’s how to solve it:

  1. Go to PivotTable Tools -> Options
    1
  2. Go to Options Under the PivotTable section
    2
  3. Check the boxes for For error values show and click OK
    3

Before

Your data will now go from looking like this:

4

After

To this:

5

Much better!

Tags

Was this post helpful?

If you enjoyed or benefited from this post, please consider any of the following:
  • post with your friends
  • Leave a comment below
  • Donate cash to support this site.

Post Navigation