Problem: Sometimes, you may want to have a few AutoShapes that are connected as a group. That way, when you move one AutoShape, they will all move together.
See all Microsoft Excel tips
Strategy: Group the AutoShapes. Using the mouse, select one AutoShape. Hold down the Ctrl key while you click on additional AutoShapes. Select Draw – Group from the Drawing toolbar, as shown in Fig. 1404.
Result: When you select the shape and move it, all of the grouped shapes will move, as shown in Fig. 1405.
Gotcha: If you change the property of a grouped shape, all of the properties will change, as shown in Fig. 1406.
Summary: To group AutoShapes together, select an AutoShape and, while holding the Ctrl key down, select the other AutoShapes to be grouped, and then use Draw – Group.
Commands Discussed: Draw – Group
See all Microsoft Excel tips