Group or ungroup items

Group items at intervals

  1. Select the row or column field whose items you want to group.
  2. On the PivotTable list toolbar, click Commands and Options , and then click the Filter and Group tab.
  3. Set Group items by to a value other than (No grouping).
  4. Set Interval to the value you want. For example, if you are grouping items by prefix characters, setting Interval to 1 would group items on A, B, C, and so on.
  5. To specify the value at which grouping begins, select the Start at check box and then enter a value in the text box.
  6. To specify the value at which grouping ends, select the End at check box and then enter a value in the text box.

    Note   The end value must be higher than the start value.

Remove grouping at intervals

  1. Select the row or column field from which you want to remove grouping.
  2. Click Commands and Options on the PivotTable list toolbar, and then click the Filter and Group tab.
  3. Set Group items by to (No grouping).

Create custom groups

  1. Click the label of the parent field that contains the items you want to group, and then click Expand on the PivotTable list toolbar.
  2. Click the first item that you want to include in the group.

    To select more items, hold down the CTRL key and click each item.

  3. Right-click a selected item, and then click Group Items.
  4. Repeat steps 2 and 3 to create more groups.

Notes

Remove custom grouping

Notes