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.
I don't love being told something is not possible. And, because of that, I found a workaround that I believe should work for you. It is not exactly everything within the cell... But, I believe it is good enough.
Here I attach the solution.
Does that work for you?
Best,
Thanks, this works fine when you have only one hyperlink in cell.
I understand that having multiple hyperlinks in one cell is not possible, so in that case you need to split into multiple cells with one hyperlink in each cell.
I understand that having multiple hyperlinks in one cell is not possible, so in that case you need to split into multiple cells with one hyperlink in each cell.
That is actually not true. I just did more than one link within the same cell.
Watch it working in the file attached.
Thanks, now I see in your solution (3) sheet - problem was that this sheet was not in your file from yesterday.
Could you pls. describe step by step the procedure you used?br Peter
1. Type all the text you want into the cell.
2. Using the formula bar, select the texts you want to look like hyperlinks and format them accordingly
3. Create as many shapes (rectangles) as links you have in the cell and put each shape over (covering) each of the hyperlinks.
4. Right-click on the first shape, and select "Link" from the menu. Add the URL accordingly and click "OK"
5. Repeat step 4 for the rest of the shapes.
6. Select all shapes at once and format them so they have "No fill" and "No outline border". That way they will be completely transparent and the texts behind them are shown.
I hope that makes sense!
Best,