Exam 77-427 Microsoft Excel 2013 EXPERT
4. Create Advanced Charts and Tables
4.2   Create and Manage PivotTables: Format Data (Blank Rows)

 

pic1
no

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.

3. 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 are:

Insert Blank Line after Each Item

Remove Blank Line after Each Item

Keep going...

graphic1

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

graphic3
graphic2