How to Remove Hyperlinks in Excel

Hyperlinks in Excel can be useful, but sometimes you may need to remove them. In this guide, we will explain step by step how to remove hyperlinks in Excel.

Hyperlink is a useful feature in Excel to create a link to a web page, file, or other cell in a worksheet. However, sometimes you may want to remove hyperlinks from a specific cell or range of cells, either because you don’t need them anymore or because you want to avoid accidental clicks.

There are several ways to remove hyperlinks in Excel, depending on your needs and preferences. In this article, we will describe some of the most common and easy methods to remove hyperlinks in Excel.

How to remove hyperlinks one by one

The easiest way to remove hyperlinks from one cell is to right click at the cell and select Remove Hyperlink from the context menu. This removes the hyperlink from that cell, but it doesn’t affect the formatting of text or formulas in that cell.

You can also use the keyboard shortcut Ctrl+K to remove a hyperlink from one cell. Just select the cell that contains the hyperlink and press Ctrl+K. This opens  the Insert Hyperlink dialog box, where you can click  the Remove Link button to remove the hyperlink from that cell.

How to remove hyperlinks in bulk

If you want to remove hyperlinks from multiple cells at once, you can use the following ways:

• Use the Remove Hyperlinks Command: You can use  the Remove Hyperlinks command  available on  the Home tab  of the Edit group. Just select the range of cells containing hyperlinks and click on the Remove Hyperlinks command. This removes all hyperlinks from selected cell range, but won’t affect the formatting of text or formulas in those cells.
• Use Ctrl+A Keyboard Shortcut: You can use the keyboard shortcut Ctrl+A to select all cells in a worksheet that contain hyperlinks. Then, right click at one of selected cells and select Remove Hyperlink from the context menu. This removes all hyperlinks from that worksheet, but won’t affect the formatting of text or formulas in those cells.
• Use VBA Macros: You can use VBA macros to remove all hyperlinks from a specific worksheet or workbook. VBA macros are codes you can run in Excel to perform specific tasks automatically. To use VBA macros to remove hyperlinks, you need to open the Visual Basic Editor window  by pressing Alt+F11. Then, enter the following code in the standard module:

Sub RemoveHyperlinks()
    Dim ws As Worksheet
    Dim wb As Workbook
    Set wb=ActiveWorkbook
    'To remove hyperlinks from active worksheet, use the following lines:
    Set ws=ActiveSheet
    'To remove hyperlinks from all worksheets in active workbook, please use the following lines:
    'Set ws = wb. Worksheets(1)
    ws.Hyperlinks.Delete
End Sub

Then, run the macro by pressing F5 or clicking the Run button. It will remove all hyperlinks from the specified worksheet or workbook, but it won’t affect the formatting of text or formulas in those cells.

Conclusion

In this article, we have described several ways to remove hyperlinks in Excel, both one by one and in bulk. You can choose the method that best suits your needs and preferences. Removing hyperlinks in Excel can help you keep your data clean and accurate, and avoid accidental clicks that can cause glitches or errors.