I need to know how to turn a long column of URLs in Excel in clickable
URLs. The only way I have found so far to make a URL clickable in
Excel is to click on the cell until the cursor appears in the cell,
click on another cell, and then go back to the first cell and then its
clickable. However this is not practical when there are hundreds of
URLs in a column. I need to know how to make an entire column
clickable with one command. The URLs are all in one column and they
are in the regular format http://www.thesite.com . There must be any
easy way to do this but I have had no success discovering it yet.
 
Here is an exampleof a  WRONG solution - 
--Highlight the column of URLs

--From the Format pull-down, select Style

--In the Style Name pull-down, select Hyperlink

--Click OK


This solution does not work - it only makes the links appear like hyperlinks.

Please do not answer this question unless you know the answer. I am
trying to get an answer quickly so please dont accept this question
with the intention of researching it. please only accept it if you
actually know the answer and can supply it right away.

---

Clarification of Question by alpacaherder-ga on 01 Dec 2004 13:42 PST

The links must be clickable - that is the entire goal - to make the
links so that they open the URL with one click.

Have you tried highlighting the column and then reformatting the
column so that the text is underlined and blue?

No offense acomment, but that will just make it *look* like a
hyperlink.  You still won't be able to click it to go to a website.

On my own, I came up with a method that would require a lot of muscle,
but it's much faster than clicking around.  My method would just be to
punch F2 then enter (then repeat many many times).  F2 will edit the
current cell.  Then the enter key would accept the contents, make it a
hyperlink, and go down the column by one cell.

However, there is a much faster way.  After doing a seach on google for 

excel "text to hyperlink"

I found the following link (#2 in the results):

http://www.excelforum.com/archive/index.php/f-8-p-41.html

There is describes two methods.  The first uses a macro.  The second
uses a formula.  I tried both.

The macro is nice, but you need some basic macro knowledge to execute it.  

The downside of the formula is that the actual contents of the cell
will be a formula.  If this is good enough, then just use this.

Good luck.