8
1
Is it possible to hyperlink a url in excel automatically. I mean when the cell starts with something like http or www can I hyperlink that. Currently, I have to hit enter in the cell value in the formula bar to make the link as clickable. Also if I change the value in the cell, the link doesnt get refreshed until I hit enter. Is there a way in excel where it will automatically detect and apply a hyperlink.
1
You can create a hyperlink in Excel with the =HYPERLINK formula.
=HYPERLINK(A2) in another cellThe image below shows a (redacted) example of creating a Hyperlink (of a mapped drive) in column A with column C & B together.
Nullldata
Posted 2010-04-01T17:56:24.697
Reputation: 123
1
There is a setting that automatically links manually-entered URLs. To activate it, do the following steps.
Open the Excel Options dialog by clicking on the Office button and selecting the Excel Options button.
In the Excel Options dialog, go to the Proofing section and click the AutoCorrect Options button.
In the AutoCorrect dialog, go to the AutoFormat As You Type tab and make sure "Internet and network paths with hyperlinks" is checked.
Then you should be able to enter URLs as desired and they will be automatically turned into a hyperlink.
Firefeather
Posted 2010-04-01T17:56:24.697
Reputation: 583
Unfortunately doesn't worked! – Dr.jacky – 2015-06-25T15:57:48.563
2I think maybe @developer is talking about how you have to manually type it in. If I paste from another program a long list of urls, they do not auto-link. – Alien Life Form – 2015-04-09T18:07:19.590
7
I'm not sure if it meets your demand, but take a look at this one: http://superuser.com/questions/66130/excel-automatic-hyperlinks/66134#66134
– Mehper C. Palavuzlar – 2010-04-05T07:25:53.463It's kind of hard to tell what's being asked, but I've done my best to answer the question. Please let me know if that's not what you're looking for. – Firefeather – 2010-12-06T22:03:06.877