software

Hello,

I am trying to make an entire column of URLs into active hyperlinks in
the worksheet. I don't want to have to do this manually as I have
dozens of links in the column.

Is there a way to automate this process so that the entire column of
URLs is autmatically made into individual, active hyperlinks?

I am an Excel newbie and I am using Excel 2003 on XP.

Thanks for you help.

JXD

Use the hyperlink formulaquot;JXDquot; gt; wrote in message
...
gt; Hello,
gt;
gt; I am trying to make an entire column of URLs into active hyperlinks in
gt; the worksheet. I don't want to have to do this manually as I have
gt; dozens of links in the column.
gt;
gt; Is there a way to automate this process so that the entire column of
gt; URLs is autmatically made into individual, active hyperlinks?
gt;
gt; I am an Excel newbie and I am using Excel 2003 on XP.
gt;
gt; Thanks for you help.
gt;
gt; JXD
That would be creating a second column, assuming
the text contains the complete link address the you can use...

Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks)
www.mvps.org/dmcritchie/excel...MakeHyperlinks
a version to create Hyperlink Worksheet Formulas also available
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;Barb Reinhardtquot; gt; wrote in message ...
gt; Use the hyperlink formula
gt;
gt;
gt; quot;JXDquot; gt; wrote in message
gt; ...
gt; gt; Hello,
gt; gt;
gt; gt; I am trying to make an entire column of URLs into active hyperlinks in
gt; gt; the worksheet. I don't want to have to do this manually as I have
gt; gt; dozens of links in the column.
gt; gt;
gt; gt; Is there a way to automate this process so that the entire column of
gt; gt; URLs is autmatically made into individual, active hyperlinks?
gt; gt;
gt; gt; I am an Excel newbie and I am using Excel 2003 on XP.
gt; gt;
gt; gt; Thanks for you help.
gt; gt;
gt; gt; JXD
gt;
gt;