Making URLs clickable in Excel 2007?

[wickedDUDE]

Hello,

What is the easiest way to make a long list of URLs (2000+) clickable in Excel 2007? They are all in the same column....

Been researching this for awhile but can't seem to figure it out. Thanks!

 

[ShadowCaster]

--Highlight the column of URLs
--From the Format pull-down, select Style
--In the Style Name pull-down, select Hyperlink
--Click OK

1st result in google...

or

Select the first cell that has the URL pasted in it, then click the "F2" button and then hit the "Enter" key. You can quickly move down the column if they are all in the same column.

 

[wickedDUDE]

When I try the first option it only lets me input one URL... I want the whole column to be linked with their individual URLs...

I also tried the second option but it doesn't seem to work...

There should be a function that I can use?

 

[ShadowCaster]

Ok, I did a little fiddling around with excel 2007 too, and here is what i found:
Make 1st link in a column clickable, select the column, then goto Cell Styles and click on Hyperlink. If you don't make 1st link in a column clickable the Hyperlink option will not show there.
Good luck!

 

[onkelmicha]

2girls1cup


man where can I find it I havent seen it in ages.

 

[ShadowCaster]

2girls1cup


man where can I find it I havent seen it in ages.

2 Girls 1 Cup - 2Girls1Cup - Two Girls One Cup Original Video
try
2Guys1Stump: 2 Guys 1 Stump Original Video
too, it's even more awesome

http://www.OctopusGirl.com http://www.KidsInSandbox.info http://www.ScrollBelow.com http://www.2girls1cup.ws http://www.PainOlympics.info http://www.1man2needles.com http://www.lolshock.com http://www.ProlapseMan.com http://www.WalkTheDinosaur.com http://www.LolTrain.com http://www.FruitLauncher.com http://www.MilkFountain.com http://www.Homewares.org http://www.JapScat.org http://www.DadParty.com http://www.Hai2U.com http://www.BottleGuy.com http://www.Turdgasm.com http://www.VomitGirl.org http://www.1Priest1Nun.com http://www.BowlGirl.com http://www.EelSoup.net http://www.GoatseGirl.org http://www.ClownSong.com http://www.PhoneJapan.com http://www.WormGush.com http://www.WhipCrack.org http://www.FunnelChair.com http://www.LOLHello.com http://www.MudMonster.org http://www.NutAbuse.com http://www.SuckDude.com http://www.TubGirl.me http://www.LemonParty.biz http://www.1man1jar.org http://www.Meatspin.biz http://www.TheHomo.org http://www.Selfpwn.org http://www.Goatse.bz http://www.BlueWaffle.biz http://www.MerryHolidays.org http://www.HowToTroll.org http://www.2Girls1Finger.org http://www.2Guys1Stump.org http://www.3guys1hammer.ws http://www.1guy1cock.com http://www.1girl1pitcher.org http://www.4girlsfingerpaint.org http://www.donotwatch.org

 

[wickedDUDE]

Ok, I did a little fiddling around with excel 2007 too, and here is what i found:
Make 1st link in a column clickable, select the column, then goto Cell Styles and click on Hyperlink. If you don't make 1st link in a column clickable the Hyperlink option will not show there.
Good luck!

Thanks for looking into this... I tried this but it only gives the appearance of a hyperlink, it doesn't make the link clickable.

After spending about an hour researching this, I finally found a great addon for Excel at ASAP Utilities - The essential add-in for Excel users. FREE excel tools and macros to save time. Download Excel tools - Excel software . I used that to turn all the links into clickable URLs.

 

[ShadowCaster]

I tried this but it only gives the appearance of a hyperlink, it doesn't make the link clickable.

Oh, I should have checked it more carefully, well at least you got that resolved anyway.

edit, lol this thread is 1st in google when searching for "Making URLs clickable in Excel 2007"

 

[tencentpiece]

Oh, I should have checked it more carefully, well at least you got that resolved anyway.

edit, lol this thread is 1st in google when searching for "Making URLs clickable in Excel 2007"

Newness factor, probably won't last.