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:

or


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:

  • Type the number 1 in an empty cell;
  • Copy this cell (by either using the keyboard shortcut CTRL-C or by right-clicking on the cell with the mouse, and selecting Copy from the right-click menu);
  • Select all the cells that you want to remove the hyperlinks from;
  • With the mouse, right-click on any of the selected cells and select Paste Special... from the right-click menu;
  • The Paste Special options dialog box will pop up. Select the option Multiply and click OK.

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.