Microsoft Office Tutorials and References
In Depth Information
Add Multiple Fields to the Row or Column Area
Chapter 6: Analyzing Data with PivotTables
Add a Field to the Row
or Column Area
1 Click a cell within the
PivotTable.
2 In the PivotTable Field
List, click and drag the
field you want to add and
drop the field in either the
Row Labels section or the
Column Labels section.
1
2
Excel adds the field to the
PivotTable.
‚óŹ
Try This!
After you add a second field to the row or column
area, you can change the field positions to change
the PivotTable view. In the PivotTable Field List, use
the Row Labels or Column Labels list to click and
drag the button of the field you want to move and
then drop the field above or below an existing field
button.
More Options!
Excel does not restrict you to
just two fields in the row or
column area. Depending on
your data analysis requirements,
you are free to add three, four,
or more fields to the row area
or the column area.
 
Search JabSto ::




Custom Search