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:
- On the Edit menu, click Go To.
- Click Special.
- Click Objects, and then click OK.
- On the Format menu, click Placement, and then click Group.
To ungroup objects, use the following steps:
- Click any object in the group to select it.
- 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.
REFERENCES
"Microsoft Excel User's Guide," version 5.0, Chapter 13, "Selecting,
Grouping and Overlapping Graphic Objects"
In Microsoft Excel 5.0, for more information about objects, click the
Search button in Help and type:
graphic objects, grouping
|