Inserting Multiple Shapes

If you need to draw the same shape several times on one or more worksheets in your workbook, you can use Excel’s Lock Drawing Mode to draw as many of the same shapes as you want without having to reselect it from the Shapes gallery. This can be a timesaver and save you extra mouse clicks. Excel stays in Lock Drawing Mode until you press Esc. If a shape doesn’t look the way you want, you can change the shape instead of redrawing it.

Insert Multiple Shapes

Image Click the Insert tab.

Image Click the Shapes button.

Right-click the ...

Get Excel® 2013 On Demand now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.