excel column of url address to be active

January 9th, 2009

I have a column of email address/web address's and they are in plain text. where in the tool bar bar can I change all of them to be a link ( blue in texture and active).

e.g. if i type in www.test.com (here) it will automatically switch to an url in this program of ofice experts. i want to do the same for my excel spread sheet in that one column.

thanks

:)

Hi Dreamboat..,,

what file???

I looked at your earlier post and you didn't mention to send any file.

ttodd
;)

ttodd -
Check the style that's set up for your hyperlinking. ie, Go to Format/Style, and see what you have for hyperlink style. It's probably a matter of defining it - or modifying it - there.
Tom

Oooorrrrr, maybe you (or somebody else) have inadvertently turned off that function?

I don't know what version you're using, but in Excel XP, if you go to ToolsAutoCorrect Options and select the 'AutoFormat As You Type' tab, there is a little box you can check or uncheck under 'replace as you type' for internet/network paths w/hyperlinks.

Maybe that got un-checked?

Just an idea, at any rate.

Howdy Todd, a VBA procedure may be the way to go here. The following code will activate text links in column A. Change the letter a's in the range line to suit your needs:



Sub Act_Lnks()

Dim cl As Range

'Column A of activesheet

For Each cl In Range("a1:" & [a65536].End(xlUp).Address)

    cl.Hyperlinks.Add Anchor:=cl, Address:=cl

Next cl

End Sub

Hope this helps.

Originally posted by ttodd
Hi Dreamboat..

I tried holding down f2 / highlighting and then hitting enter .. nothing
I tried highlighting , then f2 ,, then enter nothing..

Does Excel allow this??

Thanks

Hi, me again. I just read this again, and wanted to make sure you know that what Dreamboat suggested doesn't require any sort of highlighting. She meant just select the particular cell with the address you typed, press F2, then hit enter. You don't have to do anything else inbetween.

Sometimes, just doing that will take care of some things. Go figure :)

Hi Dreamboat..

I tried holding down f2 / highlighting and then hitting enter .. nothing
I tried highlighting , then f2 ,, then enter nothing..

Does Excel allow this??

Thanks

I'm using office 97 excel..

i did try what you suggested.
quickly touch square to highlite then f2 ., but it didn't change.

Todd-ster.

Are you ready to send me your file? Or do I have to beat it out of you?

If there isn't 1000s of them, just F2 then Enter for each cell.

Well, my most recent post was a subtle hint.

(I should've asked you before, but I like to see what turns up on the board. Plus, I was VERY busy.)

#If you have any other info about this subject , Please add it free.#

Posted in xn--xhq73t94fv79a.com | edit

xhq73t94fv79a

excel column of url address to be active

Archives

Categories

Meta