When you type an entry in your worksheet that begins with any of the following prefixes, Microsoft Excel automatically creates a hyperlink:
user name@company name.comExcel does not provide a built-in method to override this behavior. However, this article contains two methods that you can use to prevent Excel from automatically creating hyperlinks.
To prevent Excel from automatically creating a hyperlink, use one of the following methods.
Disable the AutoFormatting option
- On the Tools menu, click Autocorrect Options.
- On the Autoformat As You Type tab, click to clear the Internet and network paths with hyperlinks check box.
- Click OK.
Note You can also gain access to the Autocorrect Options feature when you type a hyperlink and then click Stop Automatically Creating Hyperlinks on the smart tag button that appears.
Type an apostrophe at the beginning of the cell entryYou can type an apostrophe (') to prevent a hyperlink from being created when you make a cell entry. For example, Excel automatically creates a hyperlink when you type the following text in a cell:
http://support.microsoft.comHowever, Excel does not automatically create a hyperlink when you type the following text:
Article ID: 291209 - Last Review: Jan 31, 2007 - Revision: 1