Remove Hyperlink in Excel

Introduction to Removing Hyperlinks in Excel

When working with Excel, you may often come across hyperlinks in your spreadsheets. These hyperlinks can be useful for linking to external websites, emails, or other documents, but sometimes they can be unwanted or unnecessary. Removing hyperlinks from Excel can be a bit tricky, but there are several methods you can use to do so. In this article, we will explore the different ways to remove hyperlinks from Excel, including using the right-click menu, the “Remove Hyperlink” button, and VBA macros.

Method 1: Using the Right-Click Menu

One of the simplest ways to remove a hyperlink from Excel is to use the right-click menu. To do this, follow these steps:

• Select the cell that contains the hyperlink you want to remove.
• Right-click on the cell to open the context menu.
• Click on “Remove Hyperlink” from the menu.

This will remove the hyperlink from the cell, but keep the text intact.

Method 2: Using the “Remove Hyperlink” Button

Another way to remove hyperlinks from Excel is to use the “Remove Hyperlink” button. To access this button, follow these steps:

• Go to the “Home” tab in the Excel ribbon.
• Click on the “Editing” group.
• Click on the “Clear” button and select “Remove Hyperlinks” from the drop-down menu.

This will remove all hyperlinks from the selected cells.

Method 3: Using VBA Macros

If you need to remove hyperlinks from a large number of cells, using a VBA macro can be a more efficient way to do so. Here is an example of a VBA macro that removes hyperlinks from a selected range of cells:

Code
Sub RemoveHyperlinks()
Dim cell As Range
For Each cell In Selection
cell.Hyperlinks.Delete
Next cell
End Sub

To use this macro, follow these steps:

• Open the Visual Basic Editor by pressing “Alt + F11” or by navigating to “Developer” > “Visual Basic” in the Excel ribbon.
• In the Visual Basic Editor, click “Insert” > “Module” to insert a new module.
• Paste the macro code into the module.
• Save the macro by clicking “File” > “Save” or by pressing “Ctrl + S”.
• Return to the Excel spreadsheet and select the cells you want to remove hyperlinks from.
• Press “Alt + F8” to open the Macro dialog box.
• Select the “RemoveHyperlinks” macro and click “Run”.

📝 Note: Before running a VBA macro, make sure to enable macros in your Excel settings by going to "File" > "Options" > "Trust Center" > "Trust Center Settings" > "Macro Settings" and selecting "Enable all macros".

Removing Hyperlinks from an Entire Worksheet

If you want to remove hyperlinks from an entire worksheet, you can use the following VBA macro:

Code
Sub RemoveHyperlinksFromWorksheet()
Dim cell As Range
For Each cell In ActiveSheet.UsedRange
cell.Hyperlinks.Delete
Next cell
End Sub

To use this macro, follow the same steps as before, but select the entire worksheet instead of a range of cells.

Conclusion

Removing hyperlinks from Excel can be a bit tricky, but there are several methods you can use to do so. Whether you use the right-click menu, the “Remove Hyperlink” button, or VBA macros, you can easily remove unwanted hyperlinks from your spreadsheets. By following the steps outlined in this article, you can keep your Excel worksheets clean and organized, and avoid any potential issues that hyperlinks may cause.