Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, and 2016. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Turning Off Hyperlink Activation.
by Allen Wyatt
(last updated October 8, 2016)
When you enter a Web address or a LAN server address of a file into an Excel cell, it automatically converts to a hyperlink when you leave the cell. This is part of the "Web-aware behavior" of Excel.
If you want to turn off the automatic conversion, you can follow these steps:
Figure 1. The AutoFormat As You Type tab of the AutoCorrect dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6245) applies to Microsoft Excel 2007, 2010, 2013, and 2016. You can find a version of this tip for the older menu interface of Excel here: Turning Off Hyperlink Activation.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."