Three Ways to Remove/Delete All or Multiple Hyperlinks in Excel 2007/2010
If you are about to remove hundreds of hyperlinks in the workbook of Excel 2007, it will be tedious to do it one by one. This article will introduce ways to remove multiple links in your Excel Workbooks and Sheets.
- Remove multiple hyperlinks by using cell format (unavailable in Excel 2007);
- Remove multiple hyperlinks by using Macros;
- Remove multiple hyperlinks in ranges, sheets and workbook by one click.
Method A: Remove multiple hyperlinks by using cell format
If the hyperlinks are in the same worksheet, you can use the cell format to remove them.
Step 1. Select the range containing hyperlinks you want to remove;
Step 2. Click Home, move to Editing group and click the down arrow next to the Clear button.
Step 3. Choose Clear Hyperlinks. See screenshot (Fig.1)
Fig. 1: Clear Hyperlinks in Excel
Tip: If you have to remove hyperlinks in different worksheets, repeat the operations again.
Method B: Remove multiple hyperlinks by using Macros
If you are a skilled and professional user, you can create macros to automatically remove the hyperlinks.
Step 1. Press Alt + F11 to start the Visual Basic Editor.
Step 2. Double click the workbook you are using on the Project Explorer and type the following code:
Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub
Step 3. Save your work.
Step 4. Run the macro by pressing Alt + F8 or using the menu by View > Macros
Step 5. Select the macro you have made, it should have the name ‘RemoveHyperlinks’.
Method C: Remove multiple hyperlinks in one click
Assuming you are about to remove hyperlinks in multiple worksheets, and not all users are able to using Macro, then an available tool Kutools for Excel will help to remove multiple hyperlinks in one click.
Kutools for Excel: with more than 80 handy Excel add-ins, free to try with no limitation in 30days. Get it Now.
After installing Kutools for Excel, apply Remove Hyperlinks according to these steps:
Click on Kutools > Editing > Delete Hyperlinks.See screenshot (Fig.2)
Fig.2 Delete Hyperlinks of Kutools for Excel
Tip: After using the function, there will be a message box popping up to indicate the removing result.
The following example shows how to remove hyperlinks with Kutools for Excel. See screenshot (Fig.3)
 |
|
|
|
|
|
Fig.3 example of Delete Hyperlinks with Kutools for Excel |
Kutools for Excel
More than 100 Advanced Functions for Excel 2007 and 2010
