If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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! |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|