|
|
How to stop auto email in EXCEL?
|
|
|
|
Forum Regular
Join Date: Feb 2004
Location: San Rafael, CA
Status:
Offline
|
|
I've been using Excel since v1.0 on a Mac Plus, so I thought I knew my way around it, but this one has me stumped.
In Excel, when you type text into a cell in the format of an e-mail address, the program automatically turn that cell into a Mailto: hyperlink. Very useful for a lot of things.
But, there are time when you don't want a hot link. You just want a plan old text entry that just happens to be in e-mail address format. I can't for the life of me find a way to set preferences so that this is the default behavior. All I can do is go back and remove the hyperlinks after the fact.
Can someone pleas tell me how to turn off this particular autoformat so that e-mail addresses are handled as plain text from the get-go?
Thanks
|
Dual 1.8 G5 tower w/ Pioneer 112, 4 gb RAM, 500 & 200gb HDs
MacBook Pro 2.16 gHz Core 2 Duo, 4 gb RAM, VM Ware Fusion & Boot Camp installed with Win XP Pro (Previously used Parallels)
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
Type 'mailto: [email protected] - note the preceeding --> ' <--
Works also with formulas, dates etc. Anything that otherwise would be auto-formatted.
-t
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Feb 2004
Location: San Rafael, CA
Status:
Offline
|
|
Neat workaround. Thanks.
BUT, one of my main uses is to sort and clean long lists of e-mail addresses before uploading them to Constant Contact. I would have to remove the little ' before each one after uploading or they wouldn't work as addresses when I want them to. It would be quicker to do what I do now, which is to remove all the links just before uploading via "autoformat - none"
Isn't there some way to just turn the autoformatting off to from the get-ho?
REBOOT - I just checked it, and this workaround is better than I thought. While the ' shows in the edit bar window. It does not display in the cell itself, so when you copy & paste from the cell or upload a block, the addresses come in clean without the '.
Way cool.
(I still think there should be a simple prefs item to just turn off the auto formatting of linjks, the same way you can in Word.)
(
Last edited by Spoffo; Dec 24, 2008 at 03:45 PM.
)
|
Dual 1.8 G5 tower w/ Pioneer 112, 4 gb RAM, 500 & 200gb HDs
MacBook Pro 2.16 gHz Core 2 Duo, 4 gb RAM, VM Ware Fusion & Boot Camp installed with Win XP Pro (Previously used Parallels)
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Oct 2001
Location: San Diego, CA, USA
Status:
Offline
|
|
If I recall, there is an option in the Windows version of Excel, but it was left out on the Mac. Oops!
|
Chuck
___
"Instead of either 'multi-talented' or 'multitalented' use 'bisexual'."
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
Originally Posted by Chuckit
If I recall, there is an option in the Windows version of Excel, but it was left out on the Mac. Oops!
You are probably right. I was looking for some preferences for that in Excel for Mac, and couldn't find it. I thought I had seen those before. It must have been in the Windows version.
-t
|
|
|
|
|
|
|
|
|
Clinically Insane
Join Date: Jun 2001
Location: planning a comeback !
Status:
Offline
|
|
Originally Posted by Spoffo
REBOOT - I just checked it, and this workaround is better than I thought. While the ' shows in the edit bar window. It does not display in the cell itself, so when you copy & paste from the cell or upload a block, the addresses come in clean without the '.
Way cool.
Yes, the ' acts as a formatting instruction and will not become part of copy & paste.
Even if you export the sheet in TXT (tab delimited), the ' will not be exported.
-t
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Feb 2004
Location: San Rafael, CA
Status:
Offline
|
|
Originally Posted by Chuckit
If I recall, there is an option in the Windows version of Excel, but it was left out on the Mac. Oops!
You're right, I just checked my Windows Excel and it's right where you'd expect it to be; < TOOLS/Autocorrect options/Autoformat as you type>
Auto-formatting internet and network addresses is the default choice, but you can simply uncheck it to turn it off.
Is this part of some plot by Microsoft? Why else would they leave this off the Mac version?
|
Dual 1.8 G5 tower w/ Pioneer 112, 4 gb RAM, 500 & 200gb HDs
MacBook Pro 2.16 gHz Core 2 Duo, 4 gb RAM, VM Ware Fusion & Boot Camp installed with Win XP Pro (Previously used Parallels)
|
|
|
|
|
|
|
|
Fresh-Faced Recruit
Join Date: Dec 2012
Status:
Offline
|
|
I know this question was posed four years ago - but this may help anyone stumbling across this thread as I have just done.
Type the email address; hit Enter so it presents as a hyperlink; type cmd Z and it reverts to the text formatting.
Found this by chance and it seems to work.
|
|
|
|
|
|
|
|
|
Forum Regular
Join Date: Mar 2002
Location: San Francisco
Status:
Offline
|
|
Re: "Type the email address; hit Enter so it presents as a hyperlink; type cmd Z and it reverts to the text formatting."
FYI, this trick works for both email and web address hyperlinks in both Word and Excel.
|
21.5" iMac 2.7GHz i5; 15" FP iMac 0.8GHz G4, iPhone 5S
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Forum Rules
|
|
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
|
HTML code is Off
|
|
|
|
|
|
|
|
|
|
|
|