Microsoft Office Tutorials and References
In Depth Information
Formatting Pivot Tables
groups on this tab, you find the Show group at the end that contains the
following useful command buttons:
Field List to hide and redisplay the PivotTable Field List task pane on
the right side of the Worksheet area
+/- Buttons to hide and redisplay the expand (+) and collapse (-) buttons
in front of particular column fields or row fields that enable you to
temporarily remove and then redisplay their particular summarized values
in the pivot table
Field Headers to hide and redisplay the fields assigned to the Column
Labels and Row Labels in the pivot table
Formatting Pivot Tables
Excel 2013 makes formatting a new pivot table you’ve added to a worksheet as
quick and easy as formatting any other table of data or list of data. All you need
to do is click a cell of the pivot table to add the PivotTable Tools contextual tab
to the Ribbon and then click its Design tab to display its command buttons.
The Design tab is divided into three groups:
Layout group that enables you to add subtotals and grand totals to the
pivot table and modify its basic layout
PivotTable Style Options group that enables you to refine the pivot
table style you select for the table using the PivotTable Styles gallery to
the immediate right
PivotTable Styles group that contains the gallery of styles you can apply
to the active pivot table by clicking the desired style thumbnail
Refining the Pivot Table style
When selecting a new formatting style for your new pivot table from the
PivotTable Styles drop-down gallery, you can then use Excel’s Live Preview
feature to see how the pivot table would look in any style that you highlight
in the gallery with your mouse or touch pointer.
After selecting a style from the gallery in the PivotTable Styles group on
the Design tab, you can then refine the style using the check box command
buttons in the PivotTable Style Options group. For example, you can add
banding to the columns or rows of a style that doesn’t already use alternate
shading to add more contrast to the table data by putting a check mark in the
Search JabSto ::




Custom Search