Home

How to Insert Shapes in an Excel 2010 Worksheet

|
|  Updated:  
2016-03-27 13:57:40
Excel Sales Forecasting For Dummies
Explore Book
Buy On Amazon

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.

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.

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.

About This Article

This article is from the book: 

About the book author:

Greg Harvey is a language scholar who has traced the roots of Tolkien’s work in European folklore and pre-Christian religious beliefs. He has studied 12 languages, including Elvish, Latin, and Anglo-Saxon.