Microsoft Office Tutorials and References
In Depth Information
Using the PivotTable Tools
Once your PivotTable is created,
you can use the PivotTable tools that appear on
the ribbon (see Figure 15-7) to adjust its content
and appearance. There are two tabs within this
specialized ribbon—Options and Design—and
while you don’t have to tinker with any of them
in order to create, use, and print a PivotTable,
many of them are pretty handy.
Starting with the Options tab, it’s broken into
PivotTable. This section offers a list of the
PivotTables in the active workbook, and if
you click the Options drop-down menu,
gives you choices for generating and
viewing your PivotTable.
Active Field. If you click on one of your
Row, Column, Filter, or Value fields, all of
the options in this section become
available, enabling you to Expand and Collapse
the data associated with that field, or
access Field Settings. If you click that
button, the dialog box shown in Figure
15-8 appears, offering you choices to
apply to your report’s subtotals (click the
Custom option) and ways to print your
Use the PivotTable Tools tabs on the Ribbon
to control the functioning and appearance
of your PivotTable.
Use the Field Settings dialog box to control
subtotaling, layout, and printing options.