Microsoft Excel

Hide #DIV/0! From Excel Pivot Table

Conditional formatting #DIV/0! within Excel is easy enough, but that doesn’t work in Pivot Tables.

Luckily, there’s an option within Pivot Table options that allows you to configure what appears when an error value is raised.

Hide Div 0

Hide Div 0

Simply check For error values show: and, in my case, leave the entry blank. Or set it to 0. Whatever works best for you. Divide by zero be gone with you.

Hope this helps!

Share on Google Plus

Mike250

Australian. Sport. Passionate Cricket Fan. Go Pro. Abseiling. Snorkeling. Travel. Golf R. SQL Server Developer. Three sons. One daughter. Last Trip: Tasmania.

2 Comments

    • S.L.
    • April 3, 2015
    • Reply

    Sounds like such an easy solution. I’ve been using pivot tables for years, and I never noticed that little check box!!! Thanks!!!

  1. Yeah mate, easier than it should be! 🙂 Or something like that. A hidden in plain sight gem that one.

Leave a comment

Your email address will not be published. Required fields are marked *