On Jun 3, 5:44 pm, Dave Peterson wrote:
Another option would be to give that target cell a nice name (Insert|name
define), then you can continue to use the Insert|Hyperlink style hyperlinks.





Dave K wrote:

Hello all,
I am trying to create a hyperlink to a cell in a spreadsheet (i.e.,
"to a place in this document"). However, when I add new rows, the
hyperlink does not change to stay with the cell that I originally
created the hyperlink to.

Is there a way to create a hyperlink to a cell that will stay with
that cell even when new rows or columns are added?

Thanks for any help!

(For example, I created a hyperlink in cell A3 that links to cell A12
that contained the word "Supplies". However, when I add new rows to
the worksheet, the cell containing the word "supplies" is no longer in
cell A12, as it has moved down however many rows that I have added.)

--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks to both of you!