Hyperlink to a Particular Cell ---- but allowing flexibility to add new rows and still keep the link

[Dave K]

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.)

 

[Guest]

Hi Dave:

This is always a problem using hyperlinks to navagate within a workbook.
because the links are normally enclosed in double-quotes, they don't adjust
as rows/columns/ are added/deleted. But here is a neat trick using the
HYPERLINK function:

A formula like:


=HYPERLINK("#Sheet2!I14","go")


will "lock" in place, but:


=HYPERLINK("#"&CELL("address",Sheet3!Z100),"target")


will adjust !

 

[Dave Peterson]

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]

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 Peterson- Hide quoted text -

- Show quoted text -

Thanks to both of you!