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 (10592) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Removing Hyperlinks without a Macro.
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!
Excel will cheerfully keep track of all sorts of hyperlinks for you. If you want to change the hyperlink in some way, ...
Discover MoreConnect your worksheets with other workbooks or with the world of the Internet. The ability to add hyperlinks makes this ...
Discover MoreIf you have links in your workbook to data in other workbooks, you may want to control whether Excel updates those links ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-06-30 21:25:29
John Mann
To clariify Cindy's comment, in my Excel 2010 there is no Editing tab. However, there is an Editing group in the Home tab. In the Home - Editing group click the Clear tool and from the drop-down menu choose "Remove Hyperlinks". This converts the hyperlink to plain text.
2019-07-17 15:07:06
Philip
Multiple by one ... what will that do if the cells contain text values ? Won’t that just generate lots of errors instead of replace hyperlinks with straight text ?
2019-07-17 09:11:31
Mark Brailsford
I just use the Remove Hyperlinks option on the context menu.
2019-07-17 08:49:50
Cindy
In version 2010 (maybe other versions also), in the Editing tab of the ribbon, Clear/Clear Hyperlinks
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments