How to Insert Shapes in an Excel 2010 Worksheet

You can insert graphic shapes such as lines, rectangles, block arrows, stars, and other basic shapes in your Excel 2010 charts and worksheets. All you need to do is select a thumbnail on the Shapes drop-down gallery on the Insert tab of the Ribbon and draw the shape in the worksheet.

1

On the Insert tab, click the Shapes button in the Illustrations group.

The Shapes gallery appears, revealing nine categories of shapes, including Recently Used Shapes at the top.

2

Click a shape thumbnail to select it.

The Shapes gallery disappears and the mouse pointer changes to a crosshair.

3

Click and drag the mouse in the worksheet to create the shape in the desired size.

Drag the object until it's approximately the size you want (you can fine-tune the size later).

4

Release the mouse button.

The shape appears in the worksheet.

After you release the mouse button, the shape you've drawn in the worksheet is still selected. This is indicated by the selection handles around its perimeter and the rotation handle at the top, which you can use to reposition and resize the shape, as needed. In addition, Excel displays the Drawing Tools Format tab, and you can use the Shape Styles gallery or other command buttons to further format the shape until it's exactly the way you want it. Click anywhere outside the shape to deselect it.

blog comments powered by Disqus
Advertisement

Inside Dummies.com