Microsoft Excel: Draw More Than For Basic Shapes

Article by Mr Excel (11,387 pts ) , published Aug 25, 2008

Problem: You need a shape other than the four basic AutoShapes in the Drawing toolbar.

See all Microsoft Excel tips

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.

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.

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

Images

Fig. 1350Fig. 1351Fig. 1352Fig. 1353Fig. 1354Fig. 1355Fig. 1356
 
Subscribe to Home Office
RSS
Get free weekly updates, directly to your inbox.