How do I stop automatic hyperlinks?
 

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?

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
wrote:

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?

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

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.)

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *