Excel® 2013 On Demand

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

Click the Insert tab.

Click the Shapes button.

Right-click the ...