Forum Discussion
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.
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,
Thanks again Ricardo
Procedure works fine.
br Peter
Procedure works fine.
br Peter
- My pleasure
