User Guide

266
Chapter 11
E
Click and drag the label to the new position.
E From the context menu, choose Insert Before or Swap.
Note:MakesurethatDragtoCopyontheEditmenuisnot enabled (checked).
If Drag to Copy is enabled, deselect it.
To Group Rows or Columns and Insert Group Labels
E Activate the pivot table.
E Select the labels for the rows or columns you want to group together (click and drag
or Shift-click to select multiple labels).
E From the menus choose:
Edit
Group
Agrouplabe
l is automatically inserted. Double-click the group label to edit the
label text.
Figure 11-
2
Row and col
umn groups and labels
Column Group Label
Row
Group
Label
Clerical
Manager
Custodial
Female
Male
Total
206
10
157 363
27
74
27
84
Note:Toa
dd rows or columns to an existing group, you must first ungroup the items
currently in the group; then create a new group that includes the additional items.
To Ungrou
p Rows or Columns and Remove Group Labels
E Activat
e the pivot table.
E Select t
he group label (click anywhere in the group label) for the rows or columns
you want to ungroup.