Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create relative hyperliks inside Excellworkbook ? Sweden
Hi ("Hej" in Swedish)
When inserting hyperlink on sheet1 to sheet3 A5 and then adding a new row above A5 at sheet3 the link stays at A5, but I want it to "follow" orgin cell A5 (now cell A6). Anyone out there....? |
#2
|
|||
|
|||
Instead of using Insert|hyperlink, maybe you could use the =hyperlink()
worksheet function: David McRitchie posted this and it might help you: =HYPERLINK("#"&CELL("address",C5),C5) =HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5) =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5) If you really want to stick with the Insert|hyperlink version, you could give your target cell a nice range name (Insert|Name|define), then use that when you create the hyperlink. Crop Protection wrote: Hi ("Hej" in Swedish) When inserting hyperlink on sheet1 to sheet3 A5 and then adding a new row above A5 at sheet3 the link stays at A5, but I want it to "follow" orgin cell A5 (now cell A6). Anyone out there....? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a List inside a cell? | Excel Discussion (Misc queries) | |||
How do I create a Histogram for relative frequency distributions? | Excel Discussion (Misc queries) | |||
How do I create a bulleted list text format inside cell? | Excel Discussion (Misc queries) | |||
Is it possible to create a table inside of a cell? | Excel Discussion (Misc queries) | |||
how can I create a histogram with relative frequency? | Excel Discussion (Misc queries) |