How do I stop automatic hyperlinks?

[Guest]

When I type an email address into a cell in Excel, it automatically becomes a
hyperlink and defaults to 10-point font. While that may be convenient at
times, I also want to prepare a list of email addresses that is NOT
hyperlinked. Even when I set the style for the column to be Normal instead of
Hyperlink, as soon as I type an email address it defaults to Hyperlink style.
How do I stop that?

 

[Myrna Larson]

If you press CTRL+Z immediately after Excel does the conversion, it will be
reversed.

Otherwise, you could use a macro to remove all hyperlinks after the fact.

Sub RemoveHyperLinks()
Dim HL As Hyperlink
With ActiveSheet
If .Hyperlinks.Count <> 0 Then
For Each HL In ActiveSheet.Hyperlinks
HL.Delete
Next HL
End If
End With
End Sub



On Fri, 4 Mar 2005 17:45:02 -0800, Jim in Berkeley <Jim in

 

[Hank Scorpio]

On Fri, 4 Mar 2005 17:45:02 -0800, Jim in Berkeley <Jim in

When I type an email address into a cell in Excel, it automatically becomes a
hyperlink and defaults to 10-point font. While that may be convenient at
times, I also want to prepare a list of email addresses that is NOT
hyperlinked. Even when I set the style for the column to be Normal instead of
Hyperlink, as soon as I type an email address it defaults to Hyperlink style.
How do I stop that?

In addition to Myrna's suggestions, you can stop them from appearing
in the first place by going to the following menu item:

Tools -> Autocorrect Options... -> Autoformat as you type (tab) ->
uncheck "Internet and Network Paths with hyperlinks".

(This is in Excel XP; you haven't said which version you're using, so
I'm making a guess.)