How to Insert Pictures from Graphics Files in Excel 2010
How to Insert Clip Art into an Excel 2010 Worksheet
How to Hide Graphic Objects in Excel 2010

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.


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.


Click a shape thumbnail to select it.

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


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).


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
How to Format an Excel 2010 SmartArt Graphic
How to Insert and Format WordArt in Excel 2010
How to Add SmartArt Diagrams and Lists in Excel 2010
How to Annotate with Text Boxes in Excel 2010
Editing and Formatting Clip Art and Pictures in Excel 2010