Microsoft Office Tutorials and References
In Depth Information
Formatting PivotTables
10
In the Name field, enter Custom Style 1 .
11
In the Table Element list, click Header Row , and then click Format to open the
Format Cells dialog box.
12
On the Font page, in the Color list, click the white swatch.
13
On the Border page, in the Presets area, click Outline .
14
On the Fill page, in the Background Color area, click the purple swatch in the
lowerright corner of the color palette.
15
Click OK to close the Format Cells dialog box. The style change appears in the
Preview pane of the New PivotTable Quick Style dialog box.
16
In the Table Element list, click Second Row Stripe , and then click Format to open the
Format Cells dialog box.
17
On the Fill page, in the middle part of the Background Color area, click the eighth
swatch in the second row (it’s a light, dusty purple).
18
Click OK twice to close the Format Cells dialog box. Your format appears in the
PivotTable Styles group.
10
19
Click the More button in the lower-right corner of the PivotTable Styles group, and
then click your new style to reformat the PivotTable.
20
On the Design tool tab, in the PivotTable Style Options group, clear the Banded
Rows check box. Excel removes the banding from your PivotTable and from the
preview of the custom style.
Search JabSto ::




Custom Search