How To Turn of Hyperlinks in Excel


	How To Turn of Hyperlinks in Excel

DarrenTooCool

1-23-2009 3:49 PM

926 views

tags:

excel, microsoft, links, email, disable, off, turn, 2007

DarrenTooCool says:

Ugh, ever enter an email address or URL into Excel then have to click on the cell? It always makes the text into a link, and launches a browser or Outlook! Here is how to disable them!

1 Comment |

Add a Comment

1-23-2009 7:12 PM

Lexica

I have the options set that way and it STILL sometimes converts them into hyperlinks.

*sigh*

I hate Microsoft.

Login to Comment. Not a member yet? Sign up

Today's Top Clips

visit the Top Clips page

View the Top Clips from January 23, 2009

Embed This Clip In Your Site...

<div style="margin: 12px 0px; font-family: arial; color: #333333; background: #ffffff; border: solid 4px #e5e5e5; width: 100%; clear: left;"><div class="CM_CTB_Content_Wrap" style="margin: 0px; padding: 0px;background-color: #ffffff;"><div style="border-bottom: solid 1px #dcdcdc; white-space: nowrap; margin-bottom: 8px; background-color: #eeeeee ;background-image: url(http://clipmarks.com/images/source-bg.gif); background-repeat: repeat-x; height: 24px; line-height: 24px; vertical-align: middle; padding-bottom: 4px; color: #666666; font-size: 10px;" ><a href="http://clipmarks.com/clip-to-blog/" title="see clips that are hot right now"><img src="http://content.clipmarks.com/blog_embed/530c61f8-61b1-426c-8bed-4d0b9cdbb9c5/62EFAFE9-DCC5-4FDC-8B01-91BA66C99BA8/" alt="" width="19" height="19" border="0" style="vertical-align: middle; margin: 0px 4px; display: inline; border: none; float:none;" /></a>clipped from <a title="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html" href="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html" style="font-size: 11px;">excel.tips.net</a></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html">Turning Off Hyperlink Activation</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html">Here's how you can turn off this activation so that your URLs remain as regular text. (This tip works with Microsoft Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)</blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html"><li style="margin-left:16px;padding-left: 0px;">Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.</LI>
<li style="margin-left:16px;padding-left: 0px;">Click Proofing at the left of the dialog box.</LI>
<li style="margin-left:16px;padding-left: 0px;">Click the AutoCorrect Options button. Excel displays the AutoCorrect dialog box.</LI>
<li style="margin-left:16px;padding-left: 0px;">Make sure the AutoFormat As You Type tab is selected. (<A href="http://excel.tips.net/FigFiles/T2707F1.html">Click here</A> to see a related figure.) </LI>
<li style="margin-left:16px;padding-left: 0px;">Clear the Internet and Network Paths With Hyperlinks check box.</LI>
<li style="margin-left:16px;padding-left: 0px;">Click OK.</LI></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html"><P>The steps to follow are different if you are using Excel 2002 or Excel 2003:</p> <OL>
<li style="margin-left:16px;padding-left: 0px;">Choose AutoCorrect Functions from the Tools menu. Excel displays the AutoCorrect dialog box.</LI>
<li style="margin-left:16px;padding-left: 0px;">Make sure the AutoFormat As You Type tab is selected.</LI>
<li style="margin-left:16px;padding-left: 0px;">Clear the Internet and Network Paths With Hyperlinks check box.</LI>
<li style="margin-left:16px;padding-left: 0px;">Click OK.</LI></OL></blockquote><div style="height: 2px; font-size: 2px; background: #dcdcdc; border-bottom: solid 1px #f5f5f5; margin: 2px 4px;"></div><blockquote style="text-align: left; padding: 0px 8px; margin: 4px 0px 8px 0px; background: transparent; border: none;" cite="http://excel.tips.net/Pages/T002707_Turning_Off_Hyperlink_Activation.html">using Excel 2000, your options are severely limited—Excel doesn't allow you to turn off the conversions</blockquote></div><div style="margin: 0px 6px 6px 4px;"><table style="font-size: 11px;border-spacing: 0px;padding: 0px;" cellpadding="0" cellspacing="0" width="100%"><tr><td style="background:transparent;border-width:0px;padding:0px;">&nbsp;</td><td align="right" style="background:transparent;border-width:0px;padding:0px;width:107px" width="107"><a href="http://clipmarks.com/share/62EFAFE9-DCC5-4FDC-8B01-91BA66C99BA8/blog/" title="blog or email this clip"><img src="http://content9.clipmarks.com/images/c2b-foot.png" border="0" alt="blog it" width="107" height="17" style="border-width:0px;padding:0px;margin:0px;" /></a></td></tr></table></div></div>