User Guide

593
Options
Pivot Table O
ptions
Pivot Table
options sets the default TableLook used for new pivot table output.
TableLooks can control a variety of pivot table attributes, including the display and
width of grid lines; font style, size, and color; and background colors.
Figure 43-7
Options dialog box, P ivot Tables tab
Table
Look.
Select a TableLook from the list of files and click OK or Apply.Bydefault,
the list displays the TableLooks saved in the Looks directory of the directory in
which the program is installed. You can use one of the TableLooks provided with the
progr
am, or you can create your own in the Pivot Table Editor (choose
TableLooks
from the Format menu).
 Browse. Allows you to select a TableLook from another directory.
 Set TableLook Directory. Allows you to change the default TableLook directory.
Adjust Column Widths for. Controls the automatic adjustment of column widths in
pivot tables.