make partial text in a cell as hyperlink

mcrmg
mcrmg used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Naresh PatelFinancial Adviser

Commented:
Hi mcrmg,

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
Most Valuable Expert 2011
Top Expert 2011
Commented:
No, it is not possible to add a hyperlink to only part of the cell content in Excel. It's all or nothing, I'm afraid.

Regards,
Rory

Commented:
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.
Most Valuable Expert 2011
Top Expert 2011

Commented:
That is not actually adding a hyperlink to part of the text. The whole text is still a hyperlink.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial