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.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
Many people like to use Excel to keep track of lists of hyperlinks. Want to keep a permanent record of which hyperlinks ...
Discover MoreExcel worksheets allow you to include hyperlinks that lead to resources on the Internet. Here's how to activate those ...
Discover MoreHyperlinks to many types of Web sites rely on passing parameters in the URL. Knowing this, you can construct a dynamic ...
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 © 2019 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