Making Hyperlinks Active In Entire Column
 

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

Making Hyperlinks Active In Entire Column
 

Use the hyperlink formula


"JXD" wrote in message
...
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

Making Hyperlinks Active In Entire Column
 

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)
http://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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Barb Reinhardt" wrote in message ...
Use the hyperlink formula


"JXD" wrote in message
...
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