PivotTable Tools ->Analyze-> PivotTable->
Options
PivotTable Options:
Layout & Format
PivotTables have Options. The Options program everything from formatting the Columns when the data is updated to whether the Totals are shown.
1. Try it: Find the Layout & Format Options
The PivotTable is still selected.
Go to
PivotTable Tools ->Analyze->PivotTable.
Click on
Options.
What Do You See? The PivotTable Options are:
Layout & Format
Totals & Filters
Display
Printing
Data
Alt Text
The Layout & Format options are shown:
In the Layout section the option to Merge and center cells is unchecked (by default).
In the Format section Autofit column width and Preserve cell formatting on update are both checked on (by default).
Keep going...
