hyperlink
 

I am using hyperlink to connect cell 1 in a spreadsheet with another
cell (suppose in row 12) in the same spreadsheet. When I insert a row
before the connected cell (so, now it's row number becomes 13),
however, the hyper link does not change automatically but still link
to row 12. Is there any way to do it automatically in EXCEL. Many
thanks!

hyperlink
 

The easiest way is to assign a Name to the destination cell and then
hyperlink using the Name:

Insert Name Define...
--
Gary''s Student - gsnu2007


"Elysia" wrote:

I am using hyperlink to connect cell 1 in a spreadsheet with another
cell (suppose in row 12) in the same spreadsheet. When I insert a row
before the connected cell (so, now it's row number becomes 13),
however, the hyper link does not change automatically but still link
to row 12. Is there any way to do it automatically in EXCEL. Many
thanks!

hyperlink
 

You could use Excel's HYPERLINK worksheet function:

=HYPERLINK(A12,"What was originally A12")

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup