How to Hide Zero Values in a Microsoft Excel Pivot Table

I love pivot tables because they require absolutely NO formula or function knowledge in Microsoft Excel. With the click of a few buttons you can easily summarise your data and look like a pro with Microsoft Excel!

However sometimes pivot tables look messy because there are so many zero values.

Here’s a quick tip to hide zero values in your pivot table so they don’t display.

You’re welcome!!

For more Microsoft 365 Tips and Shortcuts for Business, subscribe to my free eNewsletter here.

or go to www.donnahanson.com.au/subscribe