Removing Hyperlinks without a Macro

Summary: If you have a whole slew of hyperlinks in a worksheet and you want to get rid of them, it's easier than you think. This approach uses the Paste Special capabilities of Excel to get rid of the unwanted links. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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:

In a blank cell, enter the number 1.
Select the cell and press Ctrl+C. The cell content (1) is now copied to the Clipboard.
Hold down the Ctrl key as you click each hyperlink you want to remove.
Display the Paste Special dialog box. (Click here to see a related figure.) (In versions of Excel before Excel 2007 choose Edit | Paste Special. In Excel 2007 display the Home tab of the ribbon, click the down-arrow under the Paste tool at the left of the ribbon, and then choose Paste Special.)
Select the Multiply radio button.
Click OK. All the hyperlinks are removed, but the text of the hyperlinks remain.
Delete the cell you created in step 1.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2373) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Removing Hyperlinks without a Macro