Page 696 - Excel 2013 All-in-One For Dummies

678 Formatting a Pivot Table
✦ Banded Rows to add and remove banding in the form of gridlines or shading (depending on the currently selected pivot table style) from the rows of the pivot table
✦ Banded Columns to add and remove banding in the form of gridlines or shading (depending on the currently selected pivot table style) from the columns of the pivot table
Figure 2-7 shows the original pivot table created from the employee data list after making the following changes:
✦ Adding the Years of Service field as a second row field and then closing the PivotTable Fields task pane
✦ Selecting the Banded Rows check box in the PivotTable Style Options group on the Design contextual tab
✦ Choosing the Show in Outline Form option from the Report Layout com- mand button’s drop-down menu in the Layout group of the Design tab
✦ Choosing the Insert Blank Line after Each Item option from the Blank Rows command button’s drop-down menu in the Layout group of the Design tab
✦ Choosing the Show All Subtotals as Bottom of Group option from the Subtotals command button’s drop-down menu in the Layout group of the Design tab
Figure 2-7:
Revised pivot table in the Outline Form with an extra blank row between each item
in the pivot table.