Home

How to Add Preset Graphic Shapes in Excel 2013

|
|  Updated:  
2016-03-26 15:50:37
Excel Sales Forecasting For Dummies
Explore Book
Buy On Amazon

In addition to online and local imported from graphics files, with Excel 2013 you can insert preset graphic shapes in your chart or worksheet by selecting their thumbnails on the Shapes drop-down gallery on the Insert tab of the Ribbon.

image0.jpg

When you open the Shapes gallery by clicking the Shapes button in the Illustrations group on the Insert tab of the Ribbon, you see that it’s divided into nine sections: Recently Used Shapes, Lines, Rectangles, Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners, and Callouts.

After you click the thumbnail of a preset shape in this drop-down gallery, the mouse pointer or Touch Pointer becomes a crosshair you use to draw the graphic by dragging it to the size you want.

After you release the mouse button or remove your finger or stylus from the touchscreen, 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, resize, and rotate the shape, if need be.

Additionally, the program activates the Format tab on the Drawing Tools contextual tab and you can use the Shape Styles gallery or other command buttons to further format the shape to the way you want it. To set the shape and remove the selection and rotation handles, click anywhere in the worksheet outside of the shape.

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.