Forum Discussion
plaurits
Jan 07, 2023Copper Contributor
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...
- Jan 09, 2023
That is actually not true. I just did more than one link within the same cell.
Watch it working in the file attached.
HansVogelaar
Jan 07, 2023MVP
You might do the following:
1) On the Insert tab of the ribbon, insert Link (or press Ctrl+K).
2) Enter the URL in the Address box. It will automatically be copied to the 'Text to display' box.
3) Edit the 'Text to display' and add some text:
4) Click OK. The entire cell will act as a hyperlink to the desired URL, but it will display the extra text:
- plauritsJan 08, 2023Copper ContributorHi Hans
Thanks for response. I know the procedure you mention, this is not what I want since the whole text is marked as hyperlink.