entering emails without hyperlink creation

P

psgny

I want to enter email addresses in an Excel column without creating
hyperlinks. I know how to turn them off in Word, but cannot find the same
option in Excel
 
J

Jim Sullivan

I have Excel 2000 and am having the same problem. Auto-correction does not
offer any options for email. This is driving me nuts.
 
J

Jim Sullivan

Thank you for your response, but I am not quite sure what I am looking for
here. I found some information on deleting or undoing hyperlinks, but I am
looking to prevent them from occuring at all when an email is typed. Could
you please be a little more specific as to what section you are referring to,
or perhaps copy and paste the solution here?

Thanks!
 
F

Frank Kabel

Hi
AFAIK you can't turn off hyperlinks in oler versions. But using these macros
you could remove them afterwards
 
M

Mike Nolan

Jim Sullivan said:
Thank you for your response, but I am not quite sure what I am looking for
here. I found some information on deleting or undoing hyperlinks, but I am
looking to prevent them from occuring at all when an email is typed. Could
you please be a little more specific as to what section you are referring to,
or perhaps copy and paste the solution here?

Thanks!
Click to expand...
 
S

SunTaxMan

I have found that this is one of those situations that you have to be
"smarter than the computer."

As you finish the text for a web site address, or an email address, the
program will automatically make the text a link - as you have discovered -
and this is what is it supposed to do.

The avenue of eliminating the link aspect is to

- type the address as you want it and then use the space bar to move away
from the address (at this point, it will become a link) then....

- use the left arrow key and return to the last letter in the address and
then backspace to eliminate the last letter and type that last letter again
and then use the right arrow key to move away from the address (NOT the space
bar), before you hit enter.

Another method with site addresses is to type wwww. instead of www. as the
beginning - finish the site address (and because you have input 4 Ws instead
of the required 3, the program will not recognize this as a web address and
will not create it to be a link. Then simply go back into the address and
backspace over one of the middle Ws. DO NOT hit enter, or use the space bar,
as you leave the last letter of the address use the right arrow key.

This has worked for me in MS Office 2000 and 2003 in Excel and Word.
 
M

Mike Nolan

hi thanks for the advice w/excel. my problem is in pasting e-mails of clients
into excel. they always com out as hyperlinks?

thanks for your time.

mike nolan
 
J

john vella

I want to enter email addresses in an Excel column without creating
hyperlinks. I know how to turn them off in Word, but cannot find the same
option in Excel
Click to expand...

* depending on your Excel version under 'Tools - autocorrection' *

this is the solution. the detailed version is:

1. Tools drop down menu
2. choose AutoCorrect Options...
3. choose the AutoFormat As You Type tab
4. uncheck box under Replace as you type, Interenet and network paths with
hyperlinks

now if you have already encountered the annoying replacement in a cell when
you return to that cell and type in an email address, it will APPEAR as if
the feature is still turned on. this is because the cell's font color and
underline have been altered. turn off Underline for that cell and put the
font color back to black and all should be good.

i hope this helps.

john
 
B

Bill J. in Katy, Texas

Thanks John!
Your response saved me hours of frustration. I didn't origianally ask the
question, but I'm glad I read all the way down this thread! Bill J.
 
Top