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, first introduced in Excel 2000.
If you want to turn off the automatic conversion, you can follow these steps if you are using Excel 2002 or Excel 2003:
Figure 1. The AutoFormat As You Type tab of the AutoCorrect dialog box.
If you are using Excel 2000, your options are severely limited—Excel doesn't allow you to turn off the conversions. All you can do is press Ctrl+Z after the hyperlink is created, or preface your entry with an apostrophe so that Excel treats it as text. You can also create an application-level event handler—which is beyond the scope of this tip—as described in the Microsoft Knowledge Base, article 233073:
http://support.microsoft.com/kb/233073
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2707) applies to Microsoft Excel 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Turning Off Hyperlink Activation.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel Data Analysis and Business Modeling today!
Got a bunch of hyperlinks you need to get rid of? Here's a handy (and simple) macro that can do the task for you.
Discover MoreBefore some features in Excel can function properly, you must have the correct permissions set for the user of the ...
Discover MoreHyperlinks can be helpful in some worksheets but bothersome in others. Here's how to get rid of any hyperlinks you don't ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments