Microsoft Office Tutorials and References
In Depth Information
PIVOTTABLE DATA AND LAYOUT
PivotTables help you answer essential questions
about your data. To extend the value of PivotTables,
Excel allows you to change the data on which they
are based and the manner in which they are laid out.
PivotTables can easily get quite complex. Fortunately,
you need not regenerate and re-edit a table every
time the underlying data changes. Instead, you can
refresh a table by clicking Refresh.
You can easily change the layout of a PivotTable by
clicking the Design tab and choosing the PivotTable
style and layout you want. Excel 2007 has many
predesigned styles from which you can choose.
You can decide whether you want your PivotTable to
have row headers, column headers, banded rows, or
banded columns. Excel 2007 also lets you display your
table in a compact, tabular, or outline form. Try each
form to determine which one displays your data best.
R EFRESH D ATA
1 Make changes to your data.
l The data changed here.
l There is no change here.
Click any cell in your PivotTable.
l The PivotTable tools become
Click the Options tab.
l Numbers and calculations reflect
changes in the data.