| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stopping hyperlink text
How to I stop Excel from automatically creating a URL for text that I type
into cells? For instance when I type in an email address and press enter, it automatically changes it into a Hyperlink. I need the text to be just normal text without hyperlink... Thanks Pieter |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping hyperlink text
"Pieter van der Walt" wrote in message
... How to I stop Excel from automatically creating a URL for text that I type into cells? For instance when I type in an email address and press enter, it automatically changes it into a Hyperlink. I need the text to be just normal text without hyperlink... Tools/ AutoCorrect Options/ AutoFormat As You Type: Deselect "Replace as you type - Internet and network paths with hyperlinks" -- David Biddulph |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping hyperlink text
Enter an apostrophe ' before you enter the email address
"Pieter van der Walt" wrote: How to I stop Excel from automatically creating a URL for text that I type into cells? For instance when I type in an email address and press enter, it automatically changes it into a Hyperlink. I need the text to be just normal text without hyperlink... Thanks Pieter |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stopping hyperlink text
Thanks!
"David Biddulph" wrote in message ... "Pieter van der Walt" wrote in message ... How to I stop Excel from automatically creating a URL for text that I type into cells? For instance when I type in an email address and press enter, it automatically changes it into a Hyperlink. I need the text to be just normal text without hyperlink... Tools/ AutoCorrect Options/ AutoFormat As You Type: Deselect "Replace as you type - Internet and network paths with hyperlinks" -- David Biddulph |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Hyperlink to Plain Text | Excel Discussion (Misc queries) | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
