![]() |
#1
|
|||
|
|||
![]()
How do I get excel 2003, and 2010 for that matter, to NOT automatically treat an email address typed into a cell as a link? Formatting the call as a number or as text doesn't work - no format seems to work. This is very irritating. Every time you touch a cell with that link it assumes you want to send a message to that address and opens an email program and you have to waste time backing out of everything. This can't be difficult but I sure can't figure it out.
|
#2
|
|||
|
|||
![]()
Follow these steps to stop creating hyperlinks for an E-mail address.
In Excel 2010: - Go to the File menu and click on Options. - Now click on Proofing in the left column. - Now click on AutoCorrect Options. - In the AutoCorrect box, click on AutoFormat As You Type tab. - Now uncheck the box of Internet and networks paths with hyperlinks. - Now click on OK twice. In Excel 2003: - Click on Tools menu. - Now click on AutoCorrect Options. - Now you see Autoformat As You Type tab. - Now clear the check box of Internet and networks paths with hyperlinks. - Now click on OK. |
#3
|
|||
|
|||
![]()
Thank you very much. Problem solved 100%. I'm very grateful and have passed the info on to others I know who have had the same issue. I've explored these tools and settings options so I'll know better how to fix other issues that might arise.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge Many URLs in one email by common email address | instantaphex | Mail Merge | 3 | 04-29-2013 05:46 PM |
![]() |
rluna68 | Outlook | 2 | 01-07-2013 12:42 PM |
Changing Cell address within a formula | vermont_past | Excel | 12 | 09-21-2012 12:15 PM |
COUNTIF and Cell address problem | ColinC | Excel | 3 | 12-24-2011 04:08 AM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |