Format Microsoft Excel Pivot Table with AutoFormat for PivotTables add-in

AutoFormat for Pivot Table - new formats & templates for Microsoft® Excel® Pivot Tables

AutoFormat for Microsoft® Excel® PivotTables

For Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000.

You have created a first-rate PivotTable in Microsoft Excel and think it would be nice to apply it time and again as a template for your other Microsoft Excel PivotTables. Try then our tool AutoFormat for PivotTables.

AutoFormat for PivotTables is an add-in for Microsoft Excel that enhances Microsoft Excel's built-in feature of PivotTable formatting. The AutoFormat for PivotTables enables you to create, store and apply your own custom formats for PivotTables in Microsoft Excel. You can save a new PivotTable format and use it as a format template for your other Microsoft Excel PivotTables.

AutoFormat for PivotTables vs. Microsoft Excel built-in Format

As well as the built-in AutoFormat, AutoFormat for PivotTables is designed for formatting Microsoft Excel PivotTables. But unlike the built-in Microsoft Excel AutoFormat, AutoFormat for PivotTables has some advanced features:

• Creates and applies unique custom formats for Microsoft Excel PivotTables.
• Doesn't change the layout of a PivotTable. You can be sure that fields are not moved between PivotTable areas, and nothing is added to or removed from your Microsoft Excel table.
• Allows you to apply several custom formats to one PivotTable in Microsoft Excel.
• Enables you to group Microsoft Excel PivotTable formats to your liking.
• Saves and restores the format of each Microsoft Excel PivotTable area (page, row, column, data fields), whenever the PivotTable layout is changed.
• Supports export of custom format templates to other PCs.
• Supports import of custom format templates from other PCs.

How AutoFormat for Microsoft Excel PivotTables works

1. AutoFormat for PivotTables adds to your Microsoft Excel a new toolbar with three buttons: Add Template, Apply Template, and Organize Templates Collection.
2. When you select a cell within a Microsoft Excel PivotTable and click the Add Template button, AutoFormat for PivotTables Templates the format of the selected PivotTable and stores the current format of you PivotTable to Templates Collection.
3. And then you can apply any of the created custom formats to your Microsoft Excel PivotTables via the Apply Template button.
4. To organize your custom format collection you can use the Organize Templates Collection button. And that's it. :)

AutoFormat for PivotTables stores:

• Number formatting
• Patterns
• Alignment
• Fonts

AutoFormat for PivotTables works efficiently with Microsoft Excel PivotTables in the Tabular mode as well as in the Outline mode.

AutoFormat for PivotTables just formats PivotTables. If you give to somebody the workbook that contains the PivotTable formatted by the AutoFormat for PivotTables, do not worry. This table will have the same look as yours. And it is not necessary for your correspondent to have AutoFormat for PivotTables installed.

We are constantly working on improving our algorithms and are looking forward to your comments and ideas, especially you suggestions on the schema of PivotTable format transfer. Once your idea is realized in AutoFormat for PivotTables you will be given a free license and free upgrades for life.

AutoFormat for PivotTables is compatible with

• OS: Microsoft Windows Vista (x32, x64), Microsoft Windows 2003, Windows XP, 2000.
• Microsoft Excel 2007, Microsoft Excel 2003, Microsoft Excel XP, Microsoft Excel 2000.