Turn off all Hyperlinks

[Guest]

How do I turn off the feature in Excel that automatically makes my text hyperlinks? I'm trying to keep a list of email addresses in ecxel, but it always turns them to a hyperlink. I can manually remove the hyperlink, but if I do anything with that cell later, it automatically turns it back into a hyperling again.

 

[Peo Sjoblom]

You can precede the email addresses with an apostrophe when you enter them..

--

Regards,

Peo Sjoblom

How do I turn off the feature in Excel that automatically makes my text

hyperlinks? I'm trying to keep a list of email addresses in ecxel, but it
always turns them to a hyperlink. I can manually remove the hyperlink, but
if I do anything with that cell later, it automatically turns it back into a
hyperling again.

 

[Ron de Bruin]

I like to add this to Peo his answer


In Excel 2002 you can turn it of

Tools>Auto correct Options
See the <AutoFormat as You Type> Tab

For older versions:
If you type in a E-mail address you can press Ctrl-Z after you
press enter to make it text

To make text from all your hyperlinks use a macro like this

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run

 

[J.E. McGimpsey]

For older versions, you can also use the technique here:

http://www.mcgimpsey.com/excel/nohyperlinks2.html