Group, ungroup, or regroup objects

Do one of the following:

ShowGroup objects

  1. Select the objects you want to group.

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

  1. On the Drawing toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), click Draw, and then click Group.

ShowUngroup objects

  1. Select the group you want to ungroup.
  2. On the Drawing toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), 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.

  1. 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 (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), click Draw, and then click Regroup.

 Note   After you have grouped objects (object: A table, chart, graphic, equation, or other form of information. Objects created in one application, for example spreadsheets, and linked or embedded in another application are OLE objects.), you can still select any single object within the group (group: A collection of objects that behave as one for the purpose of moving, resizing, or rotating them. A group can be composed of multiple sets of groups.) by first selecting the group. Then, click the object you want to select.

 
 
Applies to:
Excel 2003