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.

---

Clarification of Question by alpacaherder-ga on 01 Dec 2004 12:06 PST

Please accept this only if you can answer it right away.

---

Request for Question Clarification by pafalafa-ga on 01 Dec 2004 12:45 PST

Here's how it works for me in Excel 2002:


--Highlight the column of URLs

--From the Format pull-down, select Style

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

--Click OK


Let me know if that does the trick.


pafalafa-ga

---

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

thank you that works great. You rock! How do I pay you now?

---

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

Very odd - it makes the URLs turn blue, but they still aren't
clickable. I am using excel 2003.

---

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

This solution only makes the links LOOK like hyperlinks. It doesnt
actually make them into hyperlinks. I would appreciate it if you
withdraw your answer so that someone who actually knows the answer can
answer it.

---

Request for Question Clarification by pafalafa-ga on 01 Dec 2004 14:25 PST

I haven't answered your question, but only posted a clarification. 
You have not been charged for an answer.  The question is still wide
open, and I'm sure other researchers will post an answer if any of
them know the solution (as will I, if I figure something out!).

Good luck.

paf

---

Clarification of Question by alpacaherder-ga on 01 Dec 2004 18:05 PST

James Mar nailed it with his helpful web reference. Thanks James! I'm
going to invite him to claim the $20. His links had a source that
explained it. I have rephrased it a little bit for clarification. Here
it is:

In an adjacent column enter the formula =HYPERLINK(A1) , where A is
the column containing the addresses. This will turn it into a
hyperlink.

Then copy that cell, 
 
Then select the rest of the column below that cell
 
Paste. You should now have a column of URLs just like the existing
column, only clickable.

I have Excel 2000.  When I typed in my email address, Excel set it as
a hyperlink.  When I typed in powerline.com it did NOT set it as a
hyperlink.  But, it I type in WWW.powerline.com it did set it as a
hyperlink.

I took Pafalafa-GA suggestion and set powerline.com as a hyperlink
using the format --> style.   The link did not work.

So if you can combine your link with www. it should work.  I'll work
on a formula.  If I figure it out, I'll post it.

I just reread your question, and you said that the format the links
were in is: http://www.thesite.com.  I typed this into excel 2000 and
it set it as a hyperlink and it worked.

What vers of excel do you have?  
Have you tried using help and searching on hyperlink?

just4fun2 - thanks for the comment. The question isnt how to make a
single hyperlink - excel does that automatically. The problem is how
to take a long column of URLs and make them clickable. Its easy to
make one cell clickable - it happens automatically when you put a
cursor in the cell. The problem is how to make an entire column of
hundreds of URLs clickable at once.

Just in case...here's the same comment I posted to the same question
you asked later...

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.