Microsoft® Excel® 2010 Inside Out

Rearranging PivotTable Fields

To pivot, or rearrange, a PivotTable, drag one or more field headings from one part of the PivotTable Field List window to another. For example, by using the mouse to change this configuration of the PivotTable Field List window:

to this one:

we can change the table from the form shown in Figure 23-3 to this:

Note

If you don’t see the PivotTable Field List window, select a cell in the PivotTable. (The window disappears when ...