Preventing the Automatic Creation of Hyperlinks in Excel

When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel creates a hyperlink: http://, www., ftp://, mailto:, file://, news:, or \\. Excel also creates a hyperlink when you type an e-mail address in the following format: user name@company name.com.

 

This How To shows how you can prevent Excel from automatically creating hyperlinks.

---

How To Prevent Creation of Hyperlinks

1. Office 2007 - From the Office button select Excel Options. Click Proofing. Click Autocorrect Options.
   
   Office 2003 - From the Tools menu select Autocorrect Options.
   
   
2. Click the Autoformat As You Type tab.
3. Click to clear the Internet and network paths with hyperlinks check box.
4. Click OK to close any dialog boxes.