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.
ricardojose
Jan 08, 2023Brass Contributor
Hi, plaurits
Here I attach a file with a working solution and here I explain how I did it:
1. Right-click the cell and add the link to the website
2. Make sure the "Text to display" input is different from the "Address" input.
3. Click OK
4. Select the cell preferably using the arrows on your keyboard.
5. Go to the "Home" tab in the Ribbon
6. On the "Editing" Group. Click the dropdown of the "Clear" menu and select "Clear Formats".
7. Using the formula bar, select the text you want to display as a hyperlink and format it as desired using the commands in the "Font" group within the "Home" tab.
- plauritsJan 08, 2023Copper ContributorThanks, this is still not what I want since entire line will be shown when you hover over. See my updated description.
- HansVogelaarJan 08, 2023MVP
What you want is not possible.
- plauritsJan 08, 2023Copper ContributorThanks Hans.
That was also what I suspected, so I have marked your response as best response.
Thanks anyway
Peter