Creating hyperlinks in Excel

jmt356
SilverLounger
Posts: 2391
Joined: 28 Mar 2010, 01:49

Creating hyperlinks in Excel

Post by jmt356 »

Is it possible to highlight a word in Excel and cause it to become a hyperlink such that clicking on the word takes the user to a web site, as can be done in Word by selecting the word and pressing ctrl + k?
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78549
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating hyperlinks in Excel

Post by HansV »

In Excel, you can only assign a hyperlink to a cell as a whole. So if a cell contains (for example) three words, you cannot make just one of those words into a hyperlink.
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Creating hyperlinks in Excel

Post by Rudi »

As Hans mentions, a single word cannot be hyperlinked within a phrase, but if the "word" can be extracted from the cell based on a condition of some sort, it can be hyperlinked using a HYPERLINK function within a helper column.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.

jmt356
SilverLounger
Posts: 2391
Joined: 28 Mar 2010, 01:49

Re: Creating hyperlinks in Excel

Post by jmt356 »

When I use the arrow buttons in Excel, the entire Excel spreadsheet moves around. How can I get the arrow keys to move only the selected cell?
Regards,

JMT

User avatar
HansV
Administrator
Posts: 78549
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Creating hyperlinks in Excel

Post by HansV »

You've probably turned on Scroll Lock. Press the Scroll Lock key on the keyboard to turn it off.
If you're using a laptop that does not have a Scroll Lock key, select Start > All Programs > Accessories > Ease of Access > On-Screen Keyboard. The on-screen keyboard has a ScrLk "key".
Best wishes,
Hans

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: Creating hyperlinks in Excel

Post by Rudi »

It sounds like you have scroll lock active on your keyboard.
Press the ScrLk key to deactivate the feature.
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.