Forum Discussion
Solved
How to insert hyperlink in text part of non empty excel cell
Hi I wonder how to make multiple hyperlinks inside a non empty excel cell, s.t. only the urls are shown as hyperlinks – not the entire string in cell. E.g. Type in excel cell “this is a test of h...
That is actually not true. I just did more than one link within the same cell.
Watch it working in the file attached.
This is something that always plagued me, as I was hoping to do cross referencing between cells, like hyperlinking text to cells in other worksheets for professional documentation or to links elsewhere. This is similar to footnote references or in HTML docs where you can click on a locator, e.g. go to "Section 2" in the "Key Principles" Worksheet.
While this is a creative idea, this solution is very fragile as the moment anything changes or edited, any overlays you've created will all be out of place. I assume that this hasn't changed in the past few months and at least know the answer to this question.
While this is a creative idea, this solution is very fragile as the moment anything changes or edited, any overlays you've created will all be out of place. I assume that this hasn't changed in the past few months and at least know the answer to this question.
I completely agree and you make a great point here! -- "...solution is very fragile as the moment anything changes or edited, any overlays you've created will all be out of place".
Doing all those object overlays, etc is more work than it's worth.
