Excel: Prevent Conversion of URLs into Hyperlinks

Excel automatically converts URLs into hyperlinks. Using the steps in this tutorial, you will prevent the conversion from taking place. Additionally, the process for converting URLs back to text is discussed.

I frequently keep track of various web statistics in Excel worksheets. In this data, numerous web addresses are included. Microsoft Excel, like most Office programs, automatically coverts text that appears to be a URL into a hyperlink. Although it is useful in certain circumstances to be able to jump directly to the web page in my browser from within Excel, most of the time the hyperlinks are simply annoying.

Throughout the entire history of Excel, including Windows version 2003, 2007, 2013 and modern Mac versions 2008 and 2011, this hyperlink conversion can be blocked.

use an apostrophe to prevent text from being converted to a hyperlink

During manual text insertion, you can prevent text that contains a URL from being converted to hypertext by prefacing the text with an apostrophe.

right-click and select remove hyperlink

For example, http://www.microsoft.com would be converted to a hyperlink while ‘http://www.microsoft.com would not. The initial apostrophe does not show on your spreadsheet.

If you forget this tip and Excel converts your URL to a hyperlink, you can correct this through the following steps:

1. Right-click on the URL.
2. Select Remove Hyperlink from the menu that appears.

Sometimes you need to remove all the hyperlinks from a document in bulk. Selecting and editing each text box through the methods above would be too time-consuming.

We have created a bulk macro to remove all hyperlinks if you need to convert a large amount of hyperlinks at once.

 

 

About David Kirk

David Kirk is one of the original founders of tech-recipes and is currently serving as editor-in-chief. Not only has he been crafting tutorials for over ten years, but in his other life he also enjoys taking care of critically ill patients as an ICU physician.
View more articles by David Kirk

The Conversation

Follow the reactions below and share your own thoughts.

  • Jack

    This is useful. I always have problems with removing the hyperlinks. The right click option doesn’t always seem to work, but when I combine it with an apostrophe it seems to do the trick.