 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008TURN OFF AUTOMATIC HYPERLINK FOR WEBSITES & ADDRESSES
I like to keep lists that include columns of web addresses or email addresses. Excel automatically formats them as hyperlinks and I can find no way to turn this off. In MSWord you CAN turn off autoformating of a hyperlink. How can I turn off automatic hyperlinking? (Thanks) Sure Jeff - Excel> Preferences> AutoCorrect just like Word - clear the first checkbox. HTH |:>) Bob Jones [MVP] Office:Mac On 2/23/08 11:49 PM, in article ee8e96a.-1@webcrossing.caR9absDaxw, > I like to keep lists that include columns of web addresses or email addresses. > Excel automatically formats them as hyperlinks and I can find no way to turn > this off. In MSWord you CAN turn off autoformating of a hyperlink. How can I > turn off automatic hyperlinking? (Thanks) Thanks, but I'm using Office 2004 and don't see any option to not autocheck hyperlinks. Do you mean to turn autocheck off completely? Well, that's why it's always a good idea to mention what version you're using - the feature isn't included in 2004. In 2004 type an apostrophe before typing the address for any new entries. That's one of the options offered here: http://mcgimpsey.com/macoffice/excel/nohyperlinks.html For existing addresses you can also select & Cut the list, paste back into the desired location (same cells is fine) then Edit> Paste Special to the same cells, select Text from the list of options. You'll still have the blue font color & underlining but you can simply reformat as you wish. HTH |:>) Bob Jones [MVP] Office:Mac On 2/24/08 7:00 PM, in article ee8e96a.1@webcrossing.caR9absDaxw, > Thanks, but I'm using Office 2004 and don't see any option to not autocheck > hyperlinks. Do you mean to turn autocheck off completely? Looks like it also a good idea to mention what version of Excel that the ANSWER applies to! In Excel 2003, go to Tools >Well, that's why it's always a good idea to mention what version you're >using - the feature isn't included in 2004. [quoted text clipped - 17 lines] >> Thanks, but I'm using Office 2004 and don't see any option to not autocheck >> hyperlinks. Do you mean to turn autocheck off completely? Looks like it also a good idea to mention what version of Excel that the ANSWER applies to! In Excel 2003, go to Tools Auto Correct Options Auto Format As You Type uncheck Internet and Network Paths With Hyperlinks >Looks like it also a good idea to mention what version of Excel that the >ANSWER applies to! [quoted text clipped - 6 lines] >>> Thanks, but I'm using Office 2004 and don't see any option to not autocheck >>> hyperlinks. Do you mean to turn autocheck off completely? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.