Excel: Prevent Conversion of URLs into Hyperlinks

Contributed by David Kirk     
Tagged: Microsoft Excel  

Excel automatically converts URLs into hyperlinks. This explains how to prevent this from happening.

Excel, like most office programs, automatically coverts text that appears to be an URL into a hyperlink.

You can prevent this from happening by prefacing the url text with an apostrophe.

http://www.tech-recipes.com will be converted into http://www.tech-recipes.com

‘http://www.tech-recipes.com will be displayed as http://www.tech-recipes.com

If you forget this tip and excel converts your URL to a hyperlink, you can correct this:

[list]Excel 2003

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

Excel Previous Versions

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