Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I prevent email addresses from automatically hyperlinking.
I want to store email addresses in Excel without necessarily creating
hyperlinks. In my old Excel software, you had to hit enter while you were in the cell to create a hyperlink, but in this new version (2003) it automatically hyperlionks the email addresses even when I just click onto a different cell. Then I have to go back everytime and remove the hyperlink. Is there a preference I can set to prevent this automatic hyperlinking? |
#2
|
|||
|
|||
Go to the Tools menu, choose AutoCorrect Options, then the "Auto
Format As You Type" tab. There, uncheck the "Internet and network paths with hyperlinks" setting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pistoff" wrote in message ... I want to store email addresses in Excel without necessarily creating hyperlinks. In my old Excel software, you had to hit enter while you were in the cell to create a hyperlink, but in this new version (2003) it automatically hyperlionks the email addresses even when I just click onto a different cell. Then I have to go back everytime and remove the hyperlink. Is there a preference I can set to prevent this automatic hyperlinking? |
#3
|
|||
|
|||
Chip
THANK YOU! You are the bomb! "Chip Pearson" wrote: Go to the Tools menu, choose AutoCorrect Options, then the "Auto Format As You Type" tab. There, uncheck the "Internet and network paths with hyperlinks" setting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "pistoff" wrote in message ... I want to store email addresses in Excel without necessarily creating hyperlinks. In my old Excel software, you had to hit enter while you were in the cell to create a hyperlink, but in this new version (2003) it automatically hyperlionks the email addresses even when I just click onto a different cell. Then I have to go back everytime and remove the hyperlink. Is there a preference I can set to prevent this automatic hyperlinking? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make XL stop interpreting email addresses as highlighted links? | Excel Discussion (Misc queries) | |||
changing email addresses | Excel Discussion (Misc queries) | |||
How do I export email addresses from excel to outlook? | Excel Discussion (Misc queries) | |||
Using CONCATENATE function to create email addresses from a list | Excel Worksheet Functions | |||
Convert entire columns of text email addresses to hyperlinks | Excel Worksheet Functions |