| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
turning hyperlink off
Is there a way to turn off hyperlink for an excel file so that manually
entering data in the spreadsheet will not convert the text into hyperlinks when the data looks like a web address or an email address? Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turning hyperlink off
Tools | Auto Correct Options | AutoFormat As You Type (tab) Helpful advice here... http://www.cpearson.com/excel/newposte.htm '-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "rockhammer" wrote in message Is there a way to turn off hyperlink for an excel file so that manually entering data in the spreadsheet will not convert the text into hyperlinks when the data looks like a web address or an email address? Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turning hyperlink off
Tools Options Spelling AutoCorrect Options and uncheck Internet and
network paths This only affects what you type and not what already exists on the sheet -- Gary''s Student - gsnu200765 "rockhammer" wrote: Is there a way to turn off hyperlink for an excel file so that manually entering data in the spreadsheet will not convert the text into hyperlinks when the data looks like a web address or an email address? Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turning hyperlink off
Wonderful, Jim. Thanks.
"Jim Cone" wrote: Tools | Auto Correct Options | AutoFormat As You Type (tab) Helpful advice here... http://www.cpearson.com/excel/newposte.htm '-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "rockhammer" wrote in message Is there a way to turn off hyperlink for an excel file so that manually entering data in the spreadsheet will not convert the text into hyperlinks when the data looks like a web address or an email address? Thanks. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
turning hyperlink off
Thanks a lot, Gary.
"Gary''s Student" wrote: Tools Options Spelling AutoCorrect Options and uncheck Internet and network paths This only affects what you type and not what already exists on the sheet -- Gary''s Student - gsnu200765 "rockhammer" wrote: Is there a way to turn off hyperlink for an excel file so that manually entering data in the spreadsheet will not convert the text into hyperlinks when the data looks like a web address or an email address? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turning =E13 to =$E$13 | Excel Worksheet Functions | |||
| keeps turning off | Excel Worksheet Functions | |||
| Turning a text file name into a search and linking the file as a hyperlink | Excel Discussion (Misc queries) | |||
| Turning #N/A to a zero...?? | Excel Discussion (Misc queries) | |||
| Turning hyperlink warning off | Excel Programming | |||
Linear Mode
