| 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 | |||
Linear Mode
