Microsoft Office Tutorials and References
In Depth Information
Controlling How Graphic Objects Overlap
Grouping graphic objects
Sometimes you may find that you need to group several graphic objects so
that they act as one unit (like a text box with its arrow). That way, you can
move these objects or size them in one operation.
To group objects, Ctrl+click each object you want to group to select them all.
Next, click the Group Objects button in the Arrange group (the one with the
picture of two entwined squares) on the Format tab under the appropriate
Tools and then click Group on its drop-down menu.
After grouping several graphic objects, whenever you click any part of the
mega-object, every part is selected (and selection handles appear only
around the perimeter of the combined object).
If you need to independently move or size grouped objects, you can ungroup
them by right-clicking an object and then choosing Group ➪ Ungroup on the
object’s shortcut menu or by clicking Group ➪ Ungroup on the Format tab
under the appropriate Tools contextual tabs.
Hiding graphic objects
The Selection task pane enables you not only to change the layering of
various graphic objects in the worksheet, but also to control whether they are
hidden or displayed. To open the Selection task pane, select one of the
graphic objects on the worksheet and then click the Format button under the
respective Tools contextual tab. Then click the Selection Pane button found
in the Arrange group of the object’s Format tab.
After you open the Selection task pane, you can temporarily hide any of the
graphic objects listed by clicking its eye check box (to remove the eye icon).
To remove the display of all the charts and graphics in the worksheet, click
the Hide All button at the top task pane instead.
To redisplay a hidden graphic object, simply click its empty eye check box
to put the eye icon back into it. To redisplay all graphic objects after hiding
them all, click the Show All button at the top of the task pane.
If you hide all the charts and graphics in a worksheet by clicking the Hide All
button and then close the Selection task pane by clicking its Close button,
you’ll have no way of redisplaying this task pane so that you can bring back
their display by clicking the Show All button. That’s because you have no
visible graphic objects left to select in the worksheet and, therefore, no way to get
the contextual tabs with their Selection Pane buttons to appear on the Ribbon.