Applying formats


show more Applying formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Applying formats

When you create a Pivot Table, Excel applies some basic formatting so you can distinguish the labels and the organizational layers from the data in the body of the Pivot Table. Excel 2008 also comes with a collection of built-in autoformats from which to choose, so you can change your Pivot Tables overall formatting if you want to. Unlike in previous versions of Excel for the Mac, it is possible to apply formatting to a Pivot Table's cell and have the formatting move with the data. In earlier versions of the program, Excel applied the formatting to the worksheet cell that currently displayed the value, and the formatting did not move when you pivoted the Pivot Table.

As an example, if I were to change the text color for this cell to red and then pivot the Pivot Table, moving Region below Year, you see that the data moved and the formatting moved with it. If you apply formatting to a Pivot Table cell and it doesn't move with the data, the option to preserve formatting might not be...

Applying formats
Video duration: 2m 26s 1h 7m Intermediate

Viewers:

Applying formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2008 for Mac: Pivot Tables for Data Analysis

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