mcrmg
asked on
make partial text in a cell as hyperlink
hi,
I know how to make a cell into a hyperlink, is there a way to make partial text in a cell as hyperlink? thx
I know how to make a cell into a hyperlink, is there a way to make partial text in a cell as hyperlink? thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rory - not true. I just did itjockey's suggestion and it worked for me. Basically, what you end up putting in the "Text to Display" window, is the only text that will show in that window, so make it meaningful. And put the link that you want it to go to, in the Link window in the bottom of that dialog box.
That is not actually adding a hyperlink to part of the text. The whole text is still a hyperlink.
Step 1 Right click on hyperlink cell & select edit hyperlink.
Step 2 very first option on popup box "Text To display". Enter what ever you want to display instead of whole URL.
Step 3 ok & Done.
Thanks