Episode 268 - Pivot Zeroes

If you pull out your copy of John M. Nelson's The Elements of Spreadsheet Style, he tells you that you should never leave blank cells in the middle of a range. Fill the blank cells with zeroes. This is spreadsheet style 101. Unfortunately, Microsoft breaks this rule in many pivot tables. Episode 268 shows you the hidden setting to fill those blanks with zeroes.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!