Written by Allen Wyatt (last updated March 16, 2021)
This tip applies to Excel 97, 2000, 2002, and 2003
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.
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!
If you want people to know something about a hyperlink you added to your worksheet, one way to help them is to use ...
Discover MoreNeed a quick link within a document to some external data? You can paste information so that Excel treats it just like a ...
Discover MoreWhen copying information from the Internet to an Excel workbook, you may want to get rid of graphics but keep any ...
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 © 2024 Sharon Parq Associates, Inc.
Comments