Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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
Posted to microsoft.public.excel.links
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |