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?

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?

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.

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