Learn Excel 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.