How To Remove All Hyperlinks In Excel

How To Remove All Hyperlinks In Excel 2003 At Once

If you want to remove all hyperlinks in a worksheet at once, you can follow this tips:

1. Select all worksheet. Shortcuts: Ctrl+A.
2. In excel main menu, click Edit, then select Copy. Shortcuts: Ctrl+C.
3. In excel main menu, click Edit, then select Paste. Shortcuts: Ctrl+V or press Enter button.

In a word, press shortcuts: Ctrl+A, Ctrl+C, Ctrl+V.

How To Remove Multiple Hyperlinks In Excel 2007 and Later

1. Select the range containing hyperlinks that you want to remove.
2. Click Home, move to Editing group and click the down arrow next to the Clear button.
3. Choose Remove Hyperlinks. See screenshot:
   
4. if you want to only clear the hyperlinks but not remove the formatting, choose Clear Hyperlinks.

or:

1. Select the range containing hyperlinks that you want to remove.
2. Press Right Button of mouse.
3. Choose Remove Hyperlinks. See screenshot:
   

What's the difference between Clear Hyperlinks and Remove Hyperlinks?

Clear Hyperlinks

Clear the hyperlinks from the selected cells. The formatting is not cleared.

Remove Hyperlinks

Remove the hyperlinks and formatting from the selected cells.

How To Remove All Hyperlinks With VBA

1. Press Alt+F11 to start the Visual Basic Editor.
2. Double click the workbook you are using on the Project Explorer and type the following code:

   Sub RemoveAllHyperlinks()
       ActiveSheet.Hyperlinks.Delete
   End Sub

   If you want to remove selected multiple hyperlinks using VBA, copy this code:

   Sub RemoveSelectedHyperlinks()
       Selection.Hyperlinks.Delete
   End Sub

3. Save your work.
4. Run the macro by pressing Alt+F8 or using the menu by View -> Macros
5. Select the macro you have made, it should have the name ‘RemoveAllHyperlinks’.