activate column of URLs as hyperlinks
 

I have a report that generates an Excel spreadsheet where one of the
columns is just URLs. However, the URLs aren't "clickable," they aren't
hyperlinks. I know that it's possible to make all of them hyperlinks
easily but I don't know how. Can anyone help?

activate column of URLs as hyperlinks
 

Why not save effort and make a double click event to follow the hyperlink
instead?

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
I have a report that generates an Excel spreadsheet where one of the
columns is just URLs. However, the URLs aren't "clickable," they aren't
hyperlinks. I know that it's possible to make all of them hyperlinks
easily but I don't know how. Can anyone help?

activate column of URLs as hyperlinks
 

I'm sorry, I don't understand. Currently they aren't hyperlinks, just a
text column of URLs. I want them to be activated and don't know how.

activate column of URLs as hyperlinks
 

Depending on what's in those cells, you may be able to use another column of
cells with formulas in them:

=hyperlink(b1)
or
=hyperlink("http://" & b1)
or
=hyperlink("http://" & b1, "Click me")

And then drag down the column.

wrote:

I'm sorry, I don't understand. Currently they aren't hyperlinks, just a
text column of URLs. I want them to be activated and don't know how.

--

Dave Peterson