Is there any way to turn off the automatic mailto link when typing an email address into a cell?
S Seorges Sep 5, 2006 #1 Is there any way to turn off the automatic mailto link when typing an email address into a cell?
D Dave Peterson Sep 5, 2006 #2 Depends on the version of excel you're using. Tools|Autocorrect options|Autoformat as you type Uncheck that "internet and network paths with hyperlinks" option. (I think xl2002+...maybe xl2k????) Or prefix your entry with an apostrophe: '[email protected] or hit ctrl-z (edit|Undo) as soon as excel jumps in with the change.
Depends on the version of excel you're using. Tools|Autocorrect options|Autoformat as you type Uncheck that "internet and network paths with hyperlinks" option. (I think xl2002+...maybe xl2k????) Or prefix your entry with an apostrophe: '[email protected] or hit ctrl-z (edit|Undo) as soon as excel jumps in with the change.
