O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Pivoting a PivotTable

To pivot, or rearrange, a PivotTable, drag one or more field headings. To move a field from the column axis to the row axis, for example, all you have to do is drag its heading from the column area to the row area.

In addition to transposing columns and rows, you can change the order in which fields are displayed on the column or row axis. For example, using Figure 30-2 as an example, you can drag the Channel heading to the left of the CatalogNo heading to produce the table shown in Figure 30-8.

We reorganized the table by dragging the Channel heading to the left of the CatalogNo heading.

Figure 30-8. We reorganized the table by dragging the Channel heading to the left of the CatalogNo heading.

Use menu commands to move ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required