Microsoft Excel: Join Two Autoshapes

Article by Mr Excel (11,387 pts ) , published Aug 25, 2008

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

Images

Fig. 1404Fig. 1405Fig. 1406
 
Subscribe to Home Office
RSS
Get free weekly updates, directly to your inbox.