Thread: 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?

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

--
Don Guillett
SalesAid Software
donaldb@281.com
<joannavaught@gmail.com> wrote in message
news:1131393077.339622.22760@g43g2000cwa.googlegroups.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.

joannavaught@gmail.com 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