#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Automatic Email Link

Is there any way to turn off the automatic mailto link when typing an email
address into a cell?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Automatic Email Link

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:



or hit ctrl-z (edit|Undo) as soon as excel jumps in with the change.

Seorges wrote:

Is there any way to turn off the automatic mailto link when typing an email
address into a cell?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Generating an automatic email? EMAIL QUESTION Excel Discussion (Misc queries) 2 June 7th 06 02:59 AM
Excel email address routing matt_gooner Excel Discussion (Misc queries) 1 May 23rd 06 07:09 PM
Finding a Problem Link in Excel Tracy B. Excel Discussion (Misc queries) 3 May 2nd 06 07:18 PM
Enable automatic refresh link Deb Bagby Excel Worksheet Functions 0 November 23rd 05 09:02 PM
stop creating email link when @ sign is present gregg Excel Discussion (Misc queries) 2 February 23rd 05 02:03 AM


All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"