Horizontal arrow between cells, with auto width, pinned to cell
Posted on 2014-04-17
I'm building a sheet to act as a hierarchical call tree, ie as a cascade of showing which staff call others in the event of a disaster.
Previously, I've used the Drawing Objects to add arrows as required, but these get scrambled when rows are added or deleted, and are tricky to precisely pin to the exact mid-point of a cell.
Is there a way that I can put an arrow into a cell so that it runs horizontally across it, and moves with the cell when we add/delete rows and columns, and preferably auto sizes to width?