Group, ungroup, or regroup objects

Microsoft Office Excel 2003

  1. Select the objects you want to group.

    To select multiple objects, hold down SHIFT while you select each object.

  2. On the Drawing toolbar, click Draw, and then click Group.

ShowUngroup objects

  1. Select the group you want to ungroup.
  2. On the Drawing toolbar, click Draw, and then click Ungroup.

    To continue ungrouping, click Yes when the message box appears.

    To change an individual object, continue to select and ungroup objects until the one you want becomes available.

  3. Use the tools on the Drawing toolbar to change the object.

ShowRegroup objects

  1. Select any one of the objects that was previously grouped.
  2. On the Drawing toolbar, click Draw, and then click Regroup.

Note  After you have grouped objects, you can still select any single object within the group by first selecting the group. Then, click the object you want to select.