Layout: Blank Rows

This PivotTable is an Outline with a couple of groups: Category and Products. You can add Blank Rows between the groups to make the PivotTable easier to read.


Before You Begin: Select the PivotTable. The PivotTable Tools should be available.

Try it: Insert Blank Rows
Go to PivotTable Tools ->Design.

Go to Layout-> Blank Rows.

Select: Insert Blank Line after Each Item

What Do You See? The options for the Blank Rows include the following:

Insert Blank Line after Each Item

Remove Blank Line after Each Item

PivotTable Tools ->Design-> Layout->Blank Rows

Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.3. Apply and manipulate PivotTables: Design Layout Blank Rows