Microsoft Office Tutorials and References
In Depth Information
Move a Field to a Different Area
Move a Field to a
Different Area
You can move a PivotTable’s fields from one
area of the PivotTable to another. This enables
you to view your data from different
perspectives, which can greatly enhance the
analysis of the data.
Moving a field within a PivotTable is called
pivoting the data. The most common way to
pivot the data is to move fields between the
row and column areas. If your PivotTable
contains just a single non-data field, moving
the field between the row and column areas
changes the orientation of the PivotTable
between horizontal (column area) and vertical
(row area). If your PivotTable contains fields in
both the row and column areas, pivoting one
of those fields to the other area creates
multiple fields in that area.
You can also pivot data by moving a row or
column field to the page area, and a page field
to the row or column area. This is a useful
technique when you want to turn one of your
existing row or column fields into a filter. For
more information, see the next section, “Apply
a Report Filter.”
Move a Field between
the Row and Column
Areas
1 Click a cell within the
PivotTable.
2 Click and drag a column
field button and drop it
within the Row Labels
area.
1
2
Excel displays the field’s
values within the row
area.
You can also drag a field
button from the Row
Labels area and drop it
within the Column Labels
area.
 
Search JabSto ::




Custom Search