hyperlinks & cell reference

  • Thread starter Thread starter Joerg Cezis
  • Start date Start date
J

Joerg Cezis

Hi folks,

Everytime I insert a new column into my Excel table the
hyperlinks which are linked to the cells don't change
automaticlly. Thus I've to change every following
hyperlink per hand.
Is there an option to relate hyperlinks to an other
reference point than the cells?

Thank you for your time in advance

Joerg
 
If I gave the range a nice name, I could use that in my hyperlink:

Using the =hyperlink() worksheet formula:

=HYPERLINK("#testname","your friendly name here")

TestName referred to c9. Inserting a new column and now it referred to D9.
 
Back
Top