Microsoft Office Tutorials and References
In Depth Information
THE FINISHED PRODUCT
Figure 9-11: The pivot table created by the PivotTable
and PivotChart Wizard
Excel’s AutoFormat feature works well with pivot tables. Select any cell in
your pivot table and then choose Format
AutoFormat. Use the AutoFormat
dialog box to select a format. The first 10 AutoFormats are listed as Reports
and the remainder are listed as Tables. AutoFormats in Report category may
change the layout of your pivot table. If you don’t like the result, choose
Edit
Undo to revert to the previous formatting.
Pivot Table Options
Excel provides plenty of options that determine how your pivot table looks and works.
To access these options, click the Options button in the final step of the PivotTable
and PivotChart Wizard to display the PivotTable Options dialog box. You also can
access this dialog box after you create the pivot table. Right-click any cell in the pivot
table and then select Table Options from the shortcut menu. Following are the options
in the PivotTable Options dialog box:
Name: You can provide a name for the pivot table. Excel provides default
names in the form of PivotTable1, PivotTable2, and so on.
Grand totals for columns: Check this box if you want Excel to calculate
grand totals for items displayed in columns.
Grand totals for rows: Check this box if you want Excel to calculate grand
totals for items displayed in rows.
AutoFormat table: Check this box if you want Excel to apply one of its
AutoFormats to the pivot table. Excel uses the AutoFormat even if you
rearrange the table layout.
Subtotal hidden page items: Check this box if you want Excel to include
hidden items in the page fields in the subtotals.
Search JabSto ::




Custom Search