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

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

Hyperlink to a Particular Cell ---- but allowing flexibility to ad
 

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 !


--
Gary''s Student - gsnu200726


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

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

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

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

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!