Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rerouting connectors
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete Connectors? | Excel Worksheet Functions | |||
How do I delete Connectors? | New Users to Excel | |||
Autoshapes and connectors | Excel Discussion (Misc queries) | |||
Connectors | Charts and Charting in Excel | |||
Comments and connectors | Excel Discussion (Misc queries) |