Excel: Prevent Conversion of URLs into Hyperlinks

Home -> Windows -> Office -> Excel

From the computer of: davak (396 recipes)
Created: Feb 08, 2004     Updated: Oct 18, 2006

Add to:

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:


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