Excel 2019: Fill in the Blanks in the Annoying Outline View
April 29, 2019 - by Bill Jelen
If your pivot table is in Tabular or Outline Form and you have more than one row field, the pivot table defaults to leaving a lot of blank cells in the outer row fields:
Starting in Excel 2010, use Design, Report Layout, Repeat all Item Labels to fill in the blanks in column A:
There is another way to have blanks in the Values area of a pivot table.
Say that you have a product which is only sold in a few regions. If there are no Doodad sales in Atlanta, Excel will leave that cell empty instead of putting a zero there. Right-click the pivot table and choose Pivot Table Options. On the Layout & Format tab, find the box For Empty Cells, Show: and type a zero.
Title Photo: Devin Avery at Unsplash.com