Excel enables you to add numerous
predesigned shapes, called AutoShapes, to your worksheets. For example,
you can insert any one of the following AutoShapes into your worksheet:
Lines, Connectors, Basic Shapes, Block Arrows, Flowchart, Stars and
Banners, Callouts, and more. AutoShapes are ideal when you don’t want
to spend the time to draw your own fancy symbols, instead preferring to
get up and running with one of Excel’s prefab symbols.
1. On the Insert tab, click the Shapes drop-down, and select from the different shape options (here, Smiley Face).
2. The mouse pointer changes to a plus sign. Click and drag the pointer to
draw the object at the desired size; then release the mouse button.
3. The new shape is added, complete with sizing handles.
Note: Resizing and Moving Objects
Move the mouse over an object border; the pointer becomes a four-headed arrow, and you can move it ; a two-headed arrow enables you to resize it . |
Note: Formatting AutoShapes
To format your
AutoShape, right-click the object, and select Format Shape from the
shortcut menu. Click the Colors and Lines tab, and choose from the
various colors, line types, and arrows. You can also use the Format tab
that appears on the ribbon after you select an Autoshape. |