Microsoft Office Tutorials and References
In Depth Information
Formatting Your PivotTable
So your PivotTable is all set. You’ve got the
right fields in the right sections, you’ve filtered
and sorted it so that you’re seeing the records
you want to see in the order you want to see
them. Now what? PivotTables in Excel 2010 are
great, certainly—they make creating a report on
your data simple and the reports themselves are
much more useful than a sorted and filtered list.
But what about the way the PivotTable looks?
As shown in the figures throughout this chapter,
PivotTables are pretty boring, visually, and if you
or the people you expect to use the report are
looking at a lot of data, you want to eliminate
that “boring” look as quickly as possible.
The familiar feel of “home” and many of
the formatting tools you learned about in
Chapter 5 can be used on your PivotTable.
To format the appearance of your PivotTable,
you use the two different ribbons:
The Home tab offers formatting options
for changing the fonts, font sizes, colors,
and fills applied to the cells in your
PivotTable. For more information on
using this tab and its Font, Alignment,
and Styles sections (shown in Figure
15-20), review Chapter 5, “Making the
Worksheet Look Good.”
The PivotTable Tools section of the
Ribbon (activated whenever you’re in a
PivotTable) offers an Options and a Design
tab. The Design tab, shown in Figure 15-21,
offers layout options for choosing what
you see in your PivotTable and how the
rows and columns are structured.
Use the PivotTable Tools’ Design tab to
apply preset PivotTable styles.