Moving, Sizing, and Arranging Graphical Objects

After creating a graphical object, you can change its position and size. You may move a graphical object to a different position on the worksheet, and you may move it in front of or in back of other graphical objects.

Note Graphical objects are anchored to the cells upon which they appear. If you shrink or expand the row height or column width of any of the cells behind a graphical object, the object will shrink or expand accordingly.

Moving Graphical Objects

To move a graphical object:

1. Select the graphical object.
2. Position the pointer anywhere in the area occupied by the graphical object. The pointer appears as an arrow.
3. Click and drag to move the graphical object. An outline of the graphical object moves with the pointer as you drag the mouse.
4. Release the mouse to set the graphical object at its new position.

Note When moving or resizing a graphical object, you can align it to the worksheet grid by pressing ALT as you click and drag.

Sizing Graphical Objects

To size a graphical object:

1. Select the graphical object.
2. Position the pointer on one of the selection handles. The pointer appears as a two-headed arrow, indicating the direction in which the graphical object can be resized.
3. Click and drag to resize the graphical object. An outline of the graphical object moves with the pointer as you drag the mouse.
4. Release the mouse to set the graphical object at its new size.

Note When moving or resizing a graphical object, you can align it to the worksheet grid by pressing ALT as you click and drag.

Arranging Graphical Objects

When you have multiple graphical objects on a worksheet, they appear to be drawn on the same plane. However, when two graphical objects overlap, the later-drawn object covers the previously drawn object. You can change the order of graphical object layering in a worksheet by sending a graphical object behind other graphical objects or bringing a graphical object to the front of other graphical objects.

All graphical objects appear in front of the cells on the worksheet. You cannot place cells in front of graphical objects.

To arrange overlapping graphical objects:

1. Select the graphical object you want to move.
2. Select Format > Bring to Front or Format > Send to Back to move the graphical object in the direction you specify.

Note The Bring to Front and Send to Back commands allow you to move a graphical object to the front or back of all other graphical objects. You cannot move an object behind another object but in front of a third object.