Excel: Prevent Conversion of URLs into Hyperlinks
Contributed by davak 
February 8, 2004 
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
Add New Comment
Viewing 1 Comment
Thanks. Your comment is awaiting approval by a moderator.
Do you already have an account? Log in and claim this comment.
Do you already have an account? Log in and claim this comment.
Add New Comment