Changing the Default PivotTable Style in Excel 2007

When you create a pivot table in Excel 2007 or 2010, a PivotTable Style is automatically applied.

If you prefer a different PivotTable Style, you can change the default PivotTable Style in a workbook, to save time when you create new pivot tables.

Follow these steps to change the default PivotTable Style:

1. Select a cell in the pivot table.
2. On the Ribbon, under the PivotTable Tools tab, click the Design tab.
3. In the PivotTable Style gallery, right-click on the style that you want to set as the default.
4. In the context menu, click on Set As Default.

More Info on Pivot Table Styles

Create a Custom Pivot Table Style

Remove a Pivot Table Style

Copy A Custom Pivot Table Style

_________