Please Note: This article is written for users of the following Microsoft Excel versions: 97, 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: Removing Hyperlinks without a Macro.
Looking for a quick, easy way to remove hyperlinks without a macro? Believe it or not, you can accomplish this by using the Paste Special features of Excel. Follow these steps:
Figure 1. The Paste Special dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2373) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Removing Hyperlinks without a Macro.
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 2013 Data Analysis and Business Modeling today!
You can create hyperlinks to all sorts of worksheets in a workbook, but you cannot create a hyperlink to a chart sheet. This ...
Discover MoreCopying information from one place to another in a worksheet is easy. Copying hyperlinks may not seem that easy, but you can ...
Discover MoreHyperlinks in a worksheet can be helpful or essential, depending on the nature of your data. If you create a link to a ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2017-06-13 12:13:51
M-Michael
Worked for me in Excel 2010. Thanks
2017-04-05 12:20:23
Ken
This solution does not work. The hyperlinks remain.
2017-02-06 05:33:45
Barry
@P Mitchell
Prefix typing your new entries with an apostrophe ( ' ) which will explicitly tell Excel to treat that entry as text.
I don't why but Excel is still parsing your input and will add hyperlinks to email addresses and website addresses, even though the cells are formatted as "Text". Other numeric input (numbers, dates, times, etc.) are not parsed and just treated as text as you'd expect.
2017-02-06 01:47:22
P Mitchell
I am a subscriber.
I have a 70+ club membership in 2000. Any time I add or modify an email address, it is changed to a hyperlink, even though the column is formatted as "text". If I am not careful it starts a browser and tries to connect...@#%&*.
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 © 2017 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 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: 
Comments