1. Start the VBA Editor – Press ALT + F11

2. On the left, double click your worksheet or workbook and copy and past the following:

Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

3. Click save.

4. Go back to your spreadsheet and press ALT + F8, select your macro, and then click the Run button.