Create, store, and use your own Excel Pivot Table templates

AutoFormat for PivotTables for Excel

With AutoFormat you can create, store and use your own formats for Excel Pivot Tables. You can save your own Pivot table format and apply it as a template for your PivotTables with one click.

AutoFormat for PivotTables for Excel is an add-in for Microsoft Excel 2003, Excel 2002 (XP), and Excel 2000.

30-day fully-functional trial version

2.8 MB

AutoFormat for PivotTables for Excel in detail

If you like well-formatted, professional looking Excel worksheets and want to save your time, check out AutoFormat for PivotTables, a handy time-saving Microsoft Excel add-in.

With AutoFormat for PivotTables you can easily create your own formats for pivot tables in Microsoft Excel. Then you can save a created format as a template and apply it later on with one mouse click.

Excel pivot table formatted with AutoFormat for PivotTables will have the same look on any PC, whether it has AutoFormat installed or not. So, without any doubts, you can share the results of your work with your colleagues or your boss;-))

With AutoFormat for PivotTables you can

• Create your custom formats for Excel pivot tables.
• Keep the layout of your pivot table. None of the fields will be misplaced, added or removed.
• Store created formats and apply them as templates for new pivots tables.
• Apply several formats to one pivot table in Microsoft Excel.
• Easy manage your format / template collection.
• Add comments to pivot table templates.
• Save and restore the format of each Microsoft Excel PivotTable area (page, row, column, data fields), whenever a pivot table layout is changed.
• Save any format options in a template : number formatting, cells alignment and font options.
• Export / import your PivotTable format collection to / from other users / PCs.
• And, save a lot of your time.

AutoFormat for PivotTables works effectively with Excel pivot tables in the Tabular mode as well as in the Outline mode.

How to work with AutoFormat for PivotTables

AutoFormat for PivotTables adds to your Microsoft Excel a new toolbar with three buttons: Add Snapshot, Apply Snapshot, and Organize Snapshots Collection

As you can see from the screenshot, AutoFormat for Excel is very easy-to-use. You can read more details bellow:

How to add a new Pivot Table format to the collection:

Select any cell within a Microsoft Excel pivot table, and click the Add Snapshot button and AutoFormat for PivotTables saves the current format of your PivotTable to the Snapshots Collection.

How to apply format template to Pivot Table

Select a snapshot you like and click the Apply Snapshot button.

How to manage your format collection:

Click the Organize Snapshots Collection button.

AutoFormat for PivotTables with

• OS: Windows® XP, Windows 2003, Windows 2000, Windows ME, Windows NT, Windows 98
• Microsoft Excel 2003, Excel XP (2002), and Excel 2000.

Download AutoFormat for PivotTables for Excel

• 30-day fully-functional trial version (2.8 MB)

See also in "Excel - Pivot Tables related add-ins"

• Pivot Table Helper for Excel - Simplify PivotTable formatting.
• Pivot Table Assistant - Simplify working with Excel Pivot Tables.