Creating a PivotTable style


show more Creating a PivotTable style provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Creating a PivotTable style

The built-in PivotTable Style gallery contains a lot of good color schemes, but they are by design somewhat generic. When you want to create your own PivotTable style to reflect your personal aesthetic or your company's graphic art guidelines, you can do so using the new PivotTable Quick Style dialog box. To display that dialog box, click any PivotTable cell and then on the Design tab of the Ribbon click the More button at the bottom-right corner of the PivotTable Styles gallery and then click New PivotTable Style.

The first thing you should do is type the name for your new PivotTable style. So if you were creating a style to reflect your company's graphic standards, you could call it something like Graphics Standards 2011. Next you click the table element you want to change and then click the Format button to display the formatting tools to apply to that element. So for example let's say that I want to change the header row's formatting. To do that, I click the header ro...

Creating a PivotTable style
Video duration: 4m 37s 3h 43m Intermediate

Viewers:

Creating a PivotTable style provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...