How can I stop Excel from creating an e-mail link for addresses?

D

debanded

I am creating a spreadsheet that includes e-mail addresses. When I enter the
e-mail address into the cell, it automatically creates a link that I can
click on to send an e-mail. I would like to just have the e-mail address
entered as text, but when I try to go back and format it as text, it won't
change it.
 
T

Therese

Hi
Use the arrowkeys to go to the cell. Then click Insert<hyperlink<remove
hyperlink.
Hope it works
 
D

debanded

Thank you! It worked!

Therese said:
Hi
Use the arrowkeys to go to the cell. Then click Insert<hyperlink<remove
hyperlink.
Hope it works

--
Therese


"debanded" skrev:
Click to expand...
 
J

John James

Hi debanded,

Select:

Tools-Autocorrect options - Autoformat as you type

Uncheck the box labelled replace as you type Internet and network paths
with hyperlinks

If you enter a new email address after this change, you won't get
hyperlinks. Copy and paste-special-formats this over existing links to
remove the links.
 
Top