activate column of URLs as hyperlinks

[joannavaught]

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?

 

[Don Guillett]

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

 

[joannavaught]

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]

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.