Learn Excel Episode 268: Pivot Zeroes

Posted in Companies, Podcasts on July 01, 2008


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.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, pivot