MS Excel

Hello,
After learning why my hyperlink was not working, now I have this question.  My cell contains a sentence.  I do not want to make the entire sentence a hyperlink, but I only want to make the hyperlink on one word.  How can I so this?
chimaAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
One thing you could do is:

Enter the text into the cell
add the hyperlink to the cell
select the cell and remove all formatting (Home ribbon > Editing panel on the right > Clear dropdown > Clear formats
  clear formats
The cell will now look like normal text, but it is still a hyperlink.
Edit the text in the cell in the Formula bar.
Select the word you want to appear as the hyperlink and format it with blue font and underline (or whatever your hyperlink format looks like).

The cell now appears to have normal text and some text appears to be a hyperlink. When you click anywhere in the cell, the hyperlink will be triggered, though, you don't have to hit the underlined text.

But at least that looks like not the whole cell is a link.

pseudo link
See attached.

Will that do?

cheers, teylyn
hyperlink-text.xlsx
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You can't. In Excel, hyperlinks apply to the whole cell.

cheers, teylyn
0
 
xcasConnect With a Mentor Commented:
the only way around it will be to place the word you want to hyperlink into a separate cell and play with the formatting to make it look like one sentence...
for example...

A1    if you want to calculate yada yada..
B1    click here  ---AND HYPERLINK CELL B1---
C1    to get the results
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Natalie KuhnConnect With a Mentor Commented:
To add - you can format the two, or however many surrounding cells, with borders/color/etc. to make it appear as though the hyperlink falls within the same cell as your sentence.
0
 
Davy2270Connect With a Mentor Commented:
If you prefer xcas' solution but resizing cells is conflicting other page layout you might want to work with 3 textboxes (form the text Commands group). They can be placed anywhere without compromising other layout.
0
 
chimaAuthor Commented:
teylyn: gee thanks for the extensive explanation.  I believe that will do, except that it is a lot of steps and for my application, which there will be many, it would be time consuming.  I will issue the points shortly, thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.