|
entering emails without hyperlink creation
I have Excel 2000 and am having the same problem. Auto-correction does not
offer any options for email. This is driving me nuts. "Frank Kabel" wrote: Hi depending on your Excel version under 'Tools - autocorrection' -- Regards Frank Kabel Frankfurt, Germany "psgny" schrieb im Newsbeitrag ... 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 |
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! "Frank Kabel" wrote: Hi see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany "Jim Sullivan" <Jim schrieb im Newsbeitrag ... I have Excel 2000 and am having the same problem. Auto-correction does not offer any options for email. This is driving me nuts. "Frank Kabel" wrote: Hi depending on your Excel version under 'Tools - autocorrection' -- Regards Frank Kabel Frankfurt, Germany "psgny" schrieb im Newsbeitrag ... 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 |
Hi
AFAIK you can't turn off hyperlinks in oler versions. But using these macros you could remove them afterwards -- Regards Frank Kabel Frankfurt, Germany "Jim Sullivan" schrieb im Newsbeitrag ... 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! "Frank Kabel" wrote: Hi see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany "Jim Sullivan" <Jim schrieb im Newsbeitrag ... I have Excel 2000 and am having the same problem. Auto-correction does not offer any options for email. This is driving me nuts. "Frank Kabel" wrote: Hi depending on your Excel version under 'Tools - autocorrection' -- Regards Frank Kabel Frankfurt, Germany "psgny" schrieb im Newsbeitrag ... 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 |
"Jim Sullivan" wrote: 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! "Frank Kabel" wrote: Hi see: http://www.mvps.org/dmcritchie/excel/buildtoc.htm (in the middle of this page) -- Regards Frank Kabel Frankfurt, Germany "Jim Sullivan" <Jim schrieb im Newsbeitrag ... I have Excel 2000 and am having the same problem. Auto-correction does not offer any options for email. This is driving me nuts. "Frank Kabel" wrote: Hi depending on your Excel version under 'Tools - autocorrection' -- Regards Frank Kabel Frankfurt, Germany "psgny" schrieb im Newsbeitrag ... 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 |
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. "psgny" wrote: 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 |
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 |
| All times are GMT +1. The time now is 04:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com