connecting cells with connector lines

[Michaelprem123]

Hello!

Is it possible in Excel (2007) to draw a connector line (with or
without an arrow ...) between two cells in a worksheet, so that the
line-tips will follow their cells even when the latter are moved ?

Thanks

Michael

 

[Alan]

Hello!

Is it possible in Excel (2007) to draw a connector line (with or
without an arrow ...) between two cells in a worksheet, so that the
line-tips will follow their cells even when the latter are moved ?

Thanks

Michael

The line will automatically adjust when rows or columns are inserted
or deleted if you select Format Autoshape>Properties>Move and size
with cells ... but you probably already knew that. However there is no
way to easily maintain the connection if a cell is dragged and dropped
to a different place on the worksheet. It is possible to use a VBA
script to delete the old line and redraw a new one but with the work
involved to write the script it may be easier to drag the end of the
line maunally unless it is a frequently recurring issue.

A.