Remove Hyperlinks in Excel
Related Page:
Create Hyperlink 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:
-
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.
or
-
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).
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:
- Use the keyboard shortcut Alt + F11 (i.e. press ALT and while holding this down, press F11), to bring up the Visual Basic Editor;
-
' Code to Remove Hyperlinks in ExcelSub RemoveAllHyperlinks()ActiveSheet.Hyperlinks.DeleteEnd Sub
Double click on the option ThisWorkbook in the Project Window, at the left of the Visual Basic Editor (see image below);
- Type (or copy and paste) the above VBA code on the right into the code window, as shown below;
- Close the VBA Editor (by clicking on the X in the top right of the window).
To run this macro:
- Select the worksheet that you want to remove the hyperlinks from;
- Use the keyboard shortcut Alt + F8 to bring up the 'Macro' dialog box;
- From the 'Macro' dialog box, select the macro ThisWorkbook.RemoveAllHyperlinks then click Run.
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.