To remove blank rows from a PivotTable: 1) Select the PivotTable. 2) On the PivotTable Tools | Design tab, point to the Blank ...