To format a pivot table and to preserve the formatting you must select the entire table (PivotTable > Select > Entire Table) and select 'Enable Selection'. Changing between nonindented format and indented format might also change the layout of the report, so that column fields become row fields or vice versa. , to a PivotTable report, and selects indented format (the Report formats) or nonindented format (the Table formats). Refreshing your pivot table will remove the formatting on your pivot chart in Excel 2000 - This is a known problem.

This command is not available if the sheet is protected. If the selection is part of a PivotTable report, the entire table, except for the page fields, is selected and formatted. If a single cell is selected, Microsoft Excel automatically selects the range surrounded by blank cells and applies the autoformat to that range. To remove an AutoFormat open the Format Report dialog box and select 'none'.Īpplies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable report. These can be used by selecting (PivotTable > Format Report). There are 21 autoformats available for your pivot tables. It is possible to apply conditional formatting to your pivot tables although this is lost when the pivot table is refreshed. The formatting will even be preserved when the column and row fields are changed. Any changes you make to your pivot table will be saved as long as the 'Preserve Formatting' option is checked on the Table Options dialog box.

Tabular pivot table