User Guide

281
Pivot Tables
Table Proper
ties: Cell Formats
For formatt
ing, a table is divided into areas: title, layers, corner labels, row labels,
column labels, data, caption, and footnotes. For each area of a table, you can modify
the associated cell formats. Cell formats include text characteristics (such as font,
size, color
, and style), horizontal and vertical alignment, cell shading, foreground and
background colors, and inner cell margins.
Figure 11-
11
Areas of a t
able
Cell formats are applied to areas (categories of information). They are not
characteristics of individual cells. This distinction is an important consideration
when pi
voting a table.
For example:
 If you specify a bold font as a cell format of column labels, the column labels
will ap
pear bold no matter what information is currently displayed in the column
dimension—and if you move an item from the column dimension to another
dimension, it does not retain the bold characteristic of the column labels.
 If you make column labels bold simply by highlighting the cells in an activated
pivot
table and clicking the Bold button on the toolbar, the contents of those
cells will remain bold no matter what dimension you move them to, and the
column labels will not retain the bold characteristic for other items moved into
the co
lumn dimension.