Please Note: This article is written for users of the following Microsoft Excel versions: 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Turning Off Hyperlink Activation.
Written by Allen Wyatt (last updated November 29, 2021)
This tip applies to Excel 2000, 2002, and 2003
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.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Need to get rid of hyperlinks in a worksheet? Here's an easy way to do it without using a macro.
Discover MoreExcel allows you to put a single hyperlink in a cell. If you have a need to put multiple hyperlinks in a cell, then you ...
Discover MoreIf you want people to know something about a hyperlink you added to your worksheet, one way to help them is to use ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-08-23 17:58:49
Allen,
While your efforts to help are very well worded, the link to the Microsoft knowledge base is a dead link. Just trying to help in your efforts, I do the same thing that you do. :)
Have a great remainder of your day.
Regards,
Trey Bolinger
Owner/Operator of KB Tech. & T.C. Transportation
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 © 2024 Sharon Parq Associates, Inc.
Comments