If you want to remove hyperlinks from one or more Excel cells, simply select the cells containing the hyperlinks and then either:
From the 'Editing' group on the Home tab of the Excel ribbon, select the option Clear → Remove Hyperlinks (see rightabove).
Note that this command will remove the hyperlinks in the selected cell(s), but the formatting of the cell(s) will remain unchanged.
Use the mouse to right-click on the selected cell(s) then, from the right-click menu, select the option Remove Hyperlink (or Remove Hyperlinks if you have more than one cell selected).
This option removes the hyperlinks and the formatting from the selected cell(s).
In Excel 2003 there is no ribbon, and you can only remove one hyperlink at a time using the right click menu. In this case, you can remove several hyperlinks at once using the following workaround:
Another way to quickly remove all hyperlinks in an Excel spreadsheet is to write a simple macro. The process for creating a macro to do this is described below:
' Code to Remove Hyperlinks in Excel
Double click on the option ThisWorkbook in the Project Window, at the left of the Visual Basic Editor (see image below);
To run this macro:
Warning: running this macro removes all hyperlinks in the worksheet permanently. You will not be able to use the undo command to return the hyperlinks to the worksheet.