Forum Discussion
Creating links within an Excel sheet that will still work after row deletions or additions
Let's say I create an index number "[1]" in cell (say) C2 . And I create the equivalent of an endnote in (say) A99 with the text "[1] Here is the text of my endnote." I now right-click on C2 ...
You can use a defined name:
Select cell A99.
Type a name in the name box on the left hand side of the formula bar, for example Endnote1, then press Enter.
When you insert or delete cells above A99, Excel will automatically adjust the definition of Endnote1.
Select C2. If you have already created the hyperlink, right-click the cell and select Edit Hyperlink from the context menu, otherwise select Link.
You should now see Endnote1 under Defined Names. Select it and proceed as usual.
Thanks for the response.
That's what I meant in my "PS". I managed to get that working and it does produce robust links. But it's a bit of a paralarva for ordinary users. The option to use a relative cell reference would be far easier for less nerdy users 🙂
