Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Apr 1 '10 at 19:42

This question came from our site for professional and enthusiast programmers.

6  
I'm not sure if it meets your demand, but take a look at this one: superuser.com/questions/66130/excel-automatic-hyperlinks/… –  Mehper C. Palavuzlar Apr 5 '10 at 7:25
    
It'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 Dec 6 '10 at 22:03

1 Answer 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.

Open the Excel Options dialog

In the Excel Options dialog, go to the Proofing section and click the AutoCorrect Options button.

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.

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.