Problem: You need a shape other than the four basic AutoShapes in the Drawing toolbar.
Strategy: In the AutoShapes dropdown, there are seven flyout menus available. Of these, five menus offer additional shapes.
1) Select the AutoShape dropdown on the toolbar, as shown in Fig. 1350. (Note: You can click any figure below to see a larger view of that image.)
2) Choose the basic shapes choice. Choose the lightning bolt. As shown in Fig. 1351, left-click in your worksheet and drag to draw a lightning bolt.
If you're using Excel 2007 or 2010, you'll find these shapes in the Illustrations grouping on the Insert tab.
Additional Details: The other shapes available are shown below. As shown in Fig. 1352, Block Arrows:
As shown in Fig. 1353, Flowchart symbols:
As shown in Fig. 1354, Stars and Banners:
As shown in Fig. 1355, Callouts. These special shapes have an anchor point that is attached to one cell. As you move the shape, it continues to be anchored to the original cell.
The More AutoShapes option opens the Insert Clipart task pane, with a number of vector-based line drawings available, as shown in Fig. 1356.
Summary: Use the AutoShape dropdown option to select from additional AutoShapes offered in Excel.
Commands Discussed: AutoShape dropdown
See all Microsoft Excel tips
