N
NoKyCard
In Excel 2003, I have sheets where I draw rectangular boxes around a group of
3 cells, then using the draw tool, draw lines connecting (and snapping to
anchor points of) the boxes.
Then, with later operations, I select 5 cells that include the cell above
and below the 3 "boxed" cells, and drag the 5 cells to another location. The
box moves with the cells, but the line does not move with the cells.
However, there is a command in the draw tolls bar to "reroute connectors",
and when I select the line that did not move with the cells, then use the
"reroute connectors" command, the line automatically reconnects to the box at
it's new location. I can move multiple boxes, then select all the arrows
involved, and with one execution of "reroute connectors", all the relocated
boxes are connected to the boxes as they were originally connected.
In Excel 2007, there does not appear to be a similar command, and I am left
with manually reconnecting each box, a very tedious task. Is there a
"reroute connectors" command in 2007 that I overlooked, or can someone
suggest another option to reconnect boxes?
As a side note, in Excel 2003, I can select the object (the box around the
cells) and move it, and the arrows move with the box. However, the contents
of the cell do not move with the box, which is why I make my box smaller than
the nmumber of cells that I manipulate.
3 cells, then using the draw tool, draw lines connecting (and snapping to
anchor points of) the boxes.
Then, with later operations, I select 5 cells that include the cell above
and below the 3 "boxed" cells, and drag the 5 cells to another location. The
box moves with the cells, but the line does not move with the cells.
However, there is a command in the draw tolls bar to "reroute connectors",
and when I select the line that did not move with the cells, then use the
"reroute connectors" command, the line automatically reconnects to the box at
it's new location. I can move multiple boxes, then select all the arrows
involved, and with one execution of "reroute connectors", all the relocated
boxes are connected to the boxes as they were originally connected.
In Excel 2007, there does not appear to be a similar command, and I am left
with manually reconnecting each box, a very tedious task. Is there a
"reroute connectors" command in 2007 that I overlooked, or can someone
suggest another option to reconnect boxes?
As a side note, in Excel 2003, I can select the object (the box around the
cells) and move it, and the arrows move with the box. However, the contents
of the cell do not move with the box, which is why I make my box smaller than
the nmumber of cells that I manipulate.