Applying a PivotTable style


show more Applying 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 ...

Applying a PivotTable style

When you create a PivotTable, Excel applies some basic formatting so you can easily distinguish with the labels and organizational layers from the data in the body of the PivotTable. Excel does come with a substantial number of built-in styles from which to choose, so if you do want to change your PivotTable's formatting you can do so easily. Before I get into styles I do want to point out that you can format individual cells within a PivotTable and have that formatting stay with us when you pivot the table. So for example let's say that I wanted to highlight the value 130 that is currently in cell C6 and I will do that just by applying a yellow fill color to that cell.

When I pivot the PivotTable, that yellow formatting will go along with that cell. So let's say that I put Company on top of the Row Labels area and when I do, the formatting has stayed with the cell that contains the value 130 and I just scroll down using my mouse wheel to display it. Then if I put Company back...

Applying a PivotTable style
Video duration: 5m 5s 3h 43m Intermediate

Viewers:

Applying 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 ...