Delete all Hyperlinks in Excel

Here is how to delete all hyperlinks in an Excel worksheet:

1. Open your Excel spreadsheet that you wish to remove the hyperlinks from.


2. Press -F11 to go to the Visual Basic editor.


3. Create a new module. You can do this by selecting Module under the Insert menu.


4. Paste the following code into your new module:

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet

ActiveSheet.Hyperlinks.Delete

End Sub

Then:

1. Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.


2. Now, go to the sheet that contains the hyperlinks that you wish to delete.


3. Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button.

Thanks to: http://www.techonthenet.com/excel/macros/delete_hl.php