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.
migrated from stackoverflow.com Apr 1 '10 at 19:42
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.