• <ALT>-F11 to go to the Visual Basic editor.
• Create a new module and add the following codes:

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

• Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.
• run Macro under tools/macro