Remove Hyperlinks in Excel

Remove Hyperlinks in Excel

If you want to remove hyperlinks from one or more Excel cells, simply select the cells containing the hyperlinks and then either:


Remove Multiple Hyperlinks in older versions of Excel

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:

Use a Macro to Remove all Hyperlinks in Excel

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:

Visual Basic Editor Showing Code to Remove All Hyperlinks in Excel

To run this macro:

Excel Window to Run the Remove All Hyperlinks 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.