How to stop an automatic email address function for a list

**Excelblows** · 05-12-2009, 02:38 PM

I am creating a list of contacts which includes their email address. When I input the address xyz@emaildomain.com and hit enter it creates an active link. I click on the cell and my email box pops up with this email ready to compose. I don't want any active links I don't want it to recognize these emails and I want to stop this.

I have tried exporting all the data converted it to .csv brought it back in an that got rid of all the links but now that I am adding new ones the problem continues. I have looked in the preferences and autoformat and can't find anything that stops this autofunction or whatever you call it.

**Special-K** · 05-12-2009, 02:43 PM

Select the cell(s) right click and select Remove Hyperlink

**DonkeyOte** · 05-12-2009, 02:47 PM

I don't have a pre2007 version at hand but in XL2007 it would be done via AutoCorrect and disabling the "Replace as you type" for "Internet and network paths with hyperlinks"... earlier versions will be similar.