Microsoft Office Tutorials and References
In Depth Information
The Arrow tool in the Drawing toolbar is used to grab many pieces of art at once
but will not grab table cells. However, you must click the arrow again to deselect it.
The Draw menu has many features, but the alignment feature is one of the most
handy. Select multiple graphic objects; then choose the alignment style.
To Fill Shapes with Text:
n Right-click a shape and you see the option to Add Text.
If you have a content-heavy design, using text boxes allows you a lot of flexibility in
where you position the text. You can make many types of text boxes in advance
and keep them as a page in your workbook, making it a simple effort to copy
and paste them where needed. Remember that you can eliminate the shape's
outline or add color.
To Fill a Shape with a Pattern:
n Right-click a shape, then select Format AutoShape, and then click the box
under Colors and Lines > Fill Effects.
In this dialog box you can fill the shape with blends of colors. You can create
oneand two-color blends in different directions and degrees of transparency. This can
provide interesting visual effects and easily dress up simple shapes.
To Group Shapes:
Select multiple shapes and then right-click to group them into one shape. If you need
to change one of the shapes, you can use the Ungroup command. Excel has the
ability to then regroup the original shapes again simply by selecting Regroup. This
can be very handy if you are dealing with a complex number of shapes.
To Order Shapes:
Shapes that are on top of other shapes can be reordered by right-clicking them and
then choosing Order. Order lets you send shapes or graphics forward or backward
in dimensional relationship with each other. You will have to ungroup any grouped
shapes to change their order.