Microsoft KB Archive/142143

= Microsoft Knowledge Base =

How to Group and Ungroup Worksheet Objects
Last reviewed: March 27, 1997

Article ID: Q142143

5.00 5.00c 7.00 | 5.00 5.00a

WINDOWS        | MACINTOSH kbusage kbhowto

The information in this article applies to:


 * Microsoft Excel for Windows, versions 5.0 and 5.0c
 * Microsoft Excel for Windows NT, version 5.0
 * Microsoft Excel for Windows 95, version 7.0
 * Microsoft Excel for the Macintosh, versions 5.0 and 5.0a
 * Microsoft Excel for the Power Macintosh, versions 5.0, 5.0a

SUMMARY
In Microsoft Excel, you can group worksheet objects together. You may want to do this, for example, in order to change the properties of all the objects in a group at one time.

MORE INFORMATION
To group objects, use the following steps:

 In a new worksheet, click Toolbars on the View menu. Click Drawing, and then click OK. Click the Text Box tool and create a text box.  Repeat step 3, and create three more text boxes. You should have a total of four text boxes on the worksheet.  Click the first text box, hold the SHIFT key down, and click two of the other text boxes. On the Format menu, point to Placement, and click Group.

Three of the four text boxes are grouped. Any action performed on the group will apply to all the items in the group.

To group all objects on a worksheet:


 * 1) On the Edit menu, click Go To.
 * 2) Click Special.
 * 3) Click Objects, and then click OK.
 * 4) On the Format menu, click Placement, and then click Group.

To ungroup objects, use the following steps:


 * 1) Click any object in the group to select it.
 * 2) On the Format menu, point to Placement, and then click Ungroup.

The objects are no longer grouped; however, because they are still selected, you will be able to manipulate the objects as a group until you click somewhere else on the sheet.