formatting text as active hyperlinks

[dpimental]

I have tried to format cells containing valid urls as hyperlinks. I can
copy the format from a valid and active hyperlink; but when I paste it
in the cell (I have tried pasting format), the contents look like a
hyperlink, but the mouse cursor does not change when I hover over it,
and I can't open the web site by clicking on it?

Any ideas?

 

[Gord Dibben]

Hyperlinks are not a Format so cannot be copied as such.

Once copied to the cell, hit F2 then <ENTER> to change to a Hyperlink.

First make sure that Tools>AutoCorrect>AutoFormat as You Type>Replace as you
Type "Internet and networks paths with hyperlinks" is checked.

Alternative..........In an adjacent cell enter =HYPERLINK(cellref)

To change a great whack all at once, use David McRitchie's macro.

Sub MakeHyperlinks()
'David McRitchie
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
With Worksheets(1)
.Hyperlinks.Add Anchor:=Cell, _
Address:=Cell.Value, _
ScreenTip:=Cell.Value, _
TextToDisplay:=Cell.Value
End With
Next Cell
End Sub

Gord Dibben Excel MVP