Microsoft Office Tutorials and References
In Depth Information
Using the Shapes tools
If you have ever used a drawing program, such as Paint or Adobe Illustrator, you already
know how to create lines, arrows, ovals, and rectangles. In Excel, as in graphics programs,
click the tool you want, and then drag the pointer to create the object. When you drag a
simple box shape using the Rectangle tool, for example, Excel displays Rectangle 1 in the
Name box at the left end of the formula bar. Excel refers to new graphic objects by
category and numbers them in the order in which you create them.
Objects you create appear to float over the worksheet or chart in a separate layer. Objects
are separate from the worksheet or chart, and you can group and format them as discrete
items. Here are a few more important facts you should know about using the drawing tools:
Excel enters drawing mode when you click a Shapes tool and exits drawing mode
when you finish drawing an object. You can cancel drawing mode by clicking the
same tool again.
Formatting you apply to underlying worksheet cells has no effect on objects.
When you move the pointer over an object, the pointer changes to a four-headed
move arrow. You can then select the object or move it elsewhere by dragging.
After you select an object, you can stretch and resize it by dragging the handles that
appear on its perimeter.
If you drag a center handle, you change the object’s height or width.
When you select a graphic object in Excel, one or more new tabs appear on the
ribbon, depending on the type of object you select. Figure 10-3 shows the Format tab
under Drawing Tools. These tabs offer additional formatting and effects you can
apply to selected objects.
Figure 10-3 A new Drawing Tools tab appears on the ribbon when you select a graphics