Simplify PivotTable formatting

Pivot Table Helper for Excel

Is a free add-in for Microsoft Excel that simplifies pivot table formatting.

Pivot Table Helper for Excel is an add-in for Microsoft Excel 2003, Excel 2002 (XP), and Excel 2000.

Setup file

650 KB

Pivot Table Helper for Excel in detail

To simplify PivotTables formatting we developed the Pivot Table Helper add-in. This add-in adds several useful buttons to AutoFormat for PivotTables for Excel toolbar:

We recommend it to all AutoFormat for PivotTables for Excel users.

Pivot Table Helper Toolbar

Select all cells of the selected Pivot Table

Select page fields area of the selected Pivot Table

Select header of the selected Pivot Table

Select blank area of the selected Pivot Table

Select origin of the selected Pivot Table

Select column fields area of the selected Pivot Table

Select row fields area of the selected Pivot Table

Select data fields area of the selected Pivot Table

Select column grand totals area of the selected Pivot Table

Select row grand totals area of the selected Pivot Table

Select subtotals area of the selected pivot field

Select the next subtotal of the selected pivot field

Set number format to the selected pivot field

Increase decimal of the selected pivot field

Decrease decimal of the selected pivot field

Set currency style to the selected pivot field

Add/remove column grand totals

Add/remove row grand totals

Changes the width of the columns of the Pivot Table to achieve the best fit

Changes the height of the rows of the Pivot Table to achieve the best fit

Examine format of the selected Pivot Table

Clear format of the selected Pivot Table

Pivot Table Helper works with

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

Download Pivot Table Helper for Excel

• Setup file (650 KB)

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

• AutoFormat for PivotTables for Excel - Create, store, and use your own Excel Pivot Table templates.
• Pivot Table Assistant - Simplify working with Excel Pivot Tables.