How to hide zero values in a Microsoft Excel 365 Pivot Table
Creating and working with pivot tables can be challenging at the best of times, let alone if your pivot table contains messy zero values. In this quick video I show you how to easily hide the zero values in your pivot table to make them look “cleaner”. Check it out Got no idea what a pivot table is? I got you… check out this video on how to use Microsoft Excel Pivot Tables. Want help with Microsoft 365 programs? Subscribe to my free monthly Productivity Pointer here or sign up at www.donnahanson.com.au/subscribe …
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 …
