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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
You can't. In Excel, hyperlinks apply to the whole cell.

cheers, teylyn
0
xcasCommented:
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
Natalie KuhnCommented:
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
The Five Tenets of the Most Secure Backup

Data loss can hit a business in any number of ways. In reality, companies should expect to lose data at some point. The challenge is having a plan to recover from such an event.

Ingeborg Hawighorst (Microsoft MVP / EE MVE)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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Davy2270Commented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.