O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Formatting a PivotTable

You can use standard formatting commands to modify the appearance of cells in a PivotTable. Excel retains your formatting preferences when you pivot your table, provided you have not cleared the Preserve Formatting check box in the PivotTable Options dialog box. If you find your formats disappearing when you pivot, choose PivotTable, Table Options, and select the Preserve Formatting check box.

Using AutoFormat with PivotTables

Excel provides 21 autoformatting options for PivotTables. You can apply these by selecting any cell in a table and choosing PivotTable, Format Report (or clicking the Format Report tool on the PivotTable toolbar). To remove autoformatting from a PivotTable, open the AutoFormat dialog box and select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required