Page 205 - Excel Workbook for Dummies

21_798452 ch15.qxp 3/13/06 7:41 PM Page 188
188 Part III: Working with Graphics

Figure 15-2:
The block
arrow and
WordArt
graphic
objects after
overlaying
and rotating.

14. Right-click on one of the letters in the WordArt graphic object and then select
Grouping➪Group on its shortcut menu.
15. Test out that you’re dealing with a single graphic object by using the → and ←
keys to move the block arrow with WordArt graphic object.
16. Widen column D to 17.27 (128 pixels).
Note the effect that widening column D has on the block arrow and the WordArt
graphic object.
17. Click the Undo button on the Standard toolbar or press Ctrl+Z to restore the
column to its original width and accordingly the composite graphic object to its
original size.
18. Open the Format Object dialog box for the composite graphic and then click the
Properties tab.
The Properties tab contains three positioning options: Move and Size with Cells
(selected by default), Move but Don’t Size with Cells, and Don’t Move or Size
with Cells. Select the Move but Don’t Size with Cells option when you want the
graphic size to remain stationary while still allowing it move with cells that it
overlays. Choose the Don’t Move or Size with Cells option when you want its size
and position to remain unaffected by changes in the cells it overlays.

19. Select the Don’t Move or Size with Cells option button before you select OK.
20. Widen column C to 26.43 (190 pixels).
This time, widening a column that the graphic object overlays has no effect on it.
21. Right-click the block arrow with WordArt graphic object and select
Grouping➪Ungroup on its shortcut menu.
22. Click one of the cells outside the block arrow or WordArt graphic object to dese-
lect both objects.