activate column of URLs as hyperlinks

J

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?
 
D

Don Guillett

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

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.
 
D

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.
 
Top