How to Remove All Hyperlinks in an Excel Spreadsheet

1. Open the spreadsheet you want to remove all the hyperlinks from.
2. Hit the “Alt' and “F11” keys to get to the Visual Basic Editor.
3. Click “Insert” on the task bar. Click “Module” from the drop-down menu. A box opens.
4. Paste the following command into the module box.Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub
5. Click “File” and “Close.” The macro is now ready for use in Excel.
6. Return to the Excel spreadsheet. Click “Tools” on the spreadsheet toolbar. Click “Macros' from the drop-down menu.
7. Click “RemoveAllHyperlinks” and then the “Run” button. The hyperlinks in the document disappear.