ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   turning hyperlink off (https://www.excelbanter.com/excel-programming/404243-turning-hyperlink-off.html)

rockhammer

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.



Jim Cone

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.



Gary''s Student

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.



rockhammer

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.




rockhammer

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.




All times are GMT +1. The time now is 12:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com