Microsoft Office Tutorials and References
In Depth Information
Spacing objects evenly
To align multiple objects, start by selecting them. Then click the Draw tool on
the Drawing toolbar. This tool expands to show a menu. Select the Align or
Distribute menu option, followed by any of the six alignment options: Align Left,
Align Center, Align Right, Align Top, Align Middle, or Align Bottom.
Unfortunately, you cannot specify which object is used as the basis for the
alignment. When you’re aligning objects to the left (or right), they are always
aligned with the left- (or right-) most object that’s selected. When you’re
aligning objects to the top (or bottom), they are always aligned with the
top(or bottom-) most object. Aligning the centers (or middles) of objects will
align them along an axis halfway between the left and right (or top and
bottom) extremes of the selected shapes.
To align objects to the cell grid when you create, resize, or move them, you need
to turn on the “snap to grid” option. In the Drawing toolbar, choose Draw
To
Grid. When that option is in effect, all objects that are created or resized will be
aligned with the cell borders. And when you move an object, its upper-left corner
will always be at a cell intersection.
You might find it easier to work with objects if you turn off the worksheet grid
lines. The snap to grid features work, even if the cell grid lines aren’t visible.
Snap
You can override the current snap to grid setting by pressing the Alt key while
you move or resize an object.
Spacing objects evenly
You can instruct Excel to “distribute” three or more objects such that they are
equally spaced horizontally or vertically. Select the objects and then click the Draw
tool on the Drawing toolbar. This tool expands to show a menu. Select the Align or
Distribute menu option, followed by either Distribute Horizontally or Distribute
Vertically.
Changing an AutoShape to a different AutoShape
You can easily change an AutoShape to a different AutoShape. Select it and then
click the Draw tool on the Drawing toolbar. Choose Change AutoShape, select the
category for the new AutoShape, and then select the AutoShape. Any formatting
applied to the AutoShape will remain.
Search JabSto ::




Custom Search