Removing the Auto Hyperlink Option in Excel

 Subscribe!

Today a colleague told me they were going crazy because they kept accidentally clicking on emails in an email list they maintained in Excel. I said, why don’t you turn off the hyperlinks then you will not have to worry about it. My colleagues face went blank….”You can do that?”.

Steps to disable auto hyperlinks (pre Excel 2007):

  1. Go to the tools menu and select “auto correct options”.
  2. Select the “AutoFormat as you type” tab 
  3. The first option is “Internet and network paths with hyperlinks”. Deselect this option.

 

Joseph Harris
Excel Help
Blog Promotion

Related posts:

  1. Removing Macros from a Workbook Q: How do I remove all the macros from my...
  2. Removing Characters from a String in Excel It is often necessary to replace characters within a string...

This entry was posted on Tuesday, December 9th, 2008 at 10:33 am and is filed under Excel Quick Tricks. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Removing the Auto Hyperlink Option in Excel”

  1. Clark on December 15th, 2008 at 9:33 am

    Thanks for posting this. Excel 2004 for Mac doesn’t seem to have these options. Any advice on where to find the setting there?

  2. Joseph Harris on December 15th, 2008 at 10:44 am

    Clark…

    Thanks for pointing this out. Unfortunately Office 2004 for MAC does not come with auto correct options.

    The two best options for you are to place an apostrophe before the email or link, this will make it a non hyperlink and will not shjow the apostrophe. The second option is two copy=>paste special as text. The links will still be highlighted and underlined but they will not be active links.

    Joe

  3. Jennine on March 4th, 2009 at 1:37 pm

    Try this out, I’ve had the same problem and I’m working on Excel 2004 for Mac. Make sure you have your formula bar on. Go to View and then formula bar. Click and edit from there instead of on the excel sheet. So highlight the e-mail address on the formula bar and then go to Insert then choose Hyperlink and then it gives you the option to Remove Hyperlink.

    I had to choose the column at the top and scroll down with the arrows to do it individually, sorry you cannot do it as a group, unless you use a macro and I found a site for that, but this is working for me.

Leave a Reply