AutoFormat for Microsoft Excel PivotTables allows you to save pivot table formatting and to use it as a format Template for your other pivot tables.
AutoFormat for PivotTables remembers formatting of each pivot table area:
- Page fields area
- Row fields area, including subtotals, blank lines and first rows
- Column fields area, including subtotals
- Data fields area
- Common pivot table areas, including row and column grand totals
AutoFormat for Excel PivotTables stores:
- Number formatting
- Borders
- Patterns
- Alignment
- Fonts
The add-in works efficiently with pivot tables in the Tabular mode as well as in the Outline mode. It doesn't change the layout of your pivot table. You can be sure that fields are not moved Between pivot table areas and nothing is added to or removed from your table. It also allows exporting / importing format templates to / from other PCs.
AutoFormat for Excel PivotTables supports for Microsoft Excel 2007, 2003, 2002, and 2000.