Excel: Add Connectors to Join Shapes

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Problem: Is there a way to join two shapes with a connector?

Strategy: All lines can be connectors.

Select Insert, Shapes dropdown and choose any of the Lines shapes. When you are about to click for the start or endpoint, hover over an existing shape. Red connector points will appear along each edge of the shape. If you start or end a line on a red connection handle, the line will be anchored to the shape.

Some shapes offer four connection points. Others offer a connection point on every corner.

  1. The triangle offers six connection points.

  2. Hover over a shape to see where the connection points are located.

    Here are several shapes with connectors. If you rearrange the shapes, the lines will continue to connect the shapes.

  3. Shapes joined by connectors.

  4. Rearrange the shapes, and the connectors stay in place.

    If you want to edit where a line connects, click on that line. Red handles will appear on the connector points. Move the red handle to a new location.

For more resources for Microsoft Excel