Afia Kona
If you want to Remove Hyperlink in Excel Permanently in an easy and quick way, this article is for you. Here we will walk you through some easy and quick methods which will help you to remove Hyperlink in Excel Permanently.
Download Workbook
4 Ways to Remove Hyperlink Permanently in Excel
There are 4 ways to remove Hyperlink permanently in Excel. We’re going to show you that with the help of the following dataset that contains several Employee ID, Name and Email ID.
Method-1: Remove Hyperlink in Excel Cell Permanently
In the following table, we want to remove Hyperlink from cell D9.
➤ To begin with, we will right click on cell D9. After that, we will see the Remove Hyperlink option. We will select this Remove Hyperlink option.
➤ Finally, we will see that the Hyperlink in cell D9 is removed.
In the similar way, you can remove Hyperlink from any cell you want.
Read More: How to Remove Hyperlink for Entire Column in Excel (5 Ways)
Method-2: Remove Hyperlink from Multiple Cells Permanently
In this section, we will show the ways of removing Hyperlink from multiple cells. Let’s explore. In the table below, we want to remove the Hyperlink from cells D5 to D9.
➤ At first, we have to select all the cells from D5 to D9. Then, we have to right click on these selected cells, and we have to select the Remove Hyperlinks option.
➤ Finally, we will see that all the cells from D5 to D9 have no Hyperlink.
Read More: How to Remove All Hyperlinks in Excel (5 Methods)
Similar Readings
- How to Copy Hyperlink in Excel (4 Easy Methods)
- Remove Excel Links from Word Document
- Excel Hyperlink with Shortcut Key (3 Uses)
- How to Remove External Links in Excel
- [Fix]: Excel Edit Links Change Source Not Working
Method-3: Remove Hyperlink by Preventing Excel from Auto Hyperlinking
We can see in the following table that when we type the E-mail ID of Andrew in cell D5, Excel automatically generates a hyperlink. We want to prevent this Auto Hyperlinking from Excel.
➤ At First, we have to select the File option.
➤ Then, we will select Options.
➤ Then, we will select the Proofing option, and then, we will select the AutoCorrect Options.
➤ After that, we have to select AutoFormat As You Type.
➤ We will see marked Internet and network paths with hyperlinks.
➤ We have to unmark this Internet and network paths with hyperlinks.
➤ And we have to click OK.
➤ Now, if we type the E-mail ID of Liza, we will see that the email is not shown as a hyperlink.
Read More: [Fix]: Excel Automatic Update of Links Has Been Disabled
Method-4: Using VBA Code
The following table shows student E-mail Id as Hyperlink. We want to remove these hyperlinks using VBA Code.
➤ To begin with, We have to type (ALT+F11) in your active worksheet, and the VBA editor window will open.
➤ we will see our selected worksheet under VBA Project. As we selected Sheet4, we can see this Sheet4 is highlighted.
➤ After double clicking on this highlighted Sheet4, we will see VBA Code window.
➤ We have to Type the following Code
Sub RemoveAllHyperlinks()
'Code by Afia Aziz [email protected]
ActiveSheet.Hyperlinks.Delete
End Sub
➤ After that, we have to close the VBA editor window.
➤ We have to open our Sheet4.
➤ We have to type (ALT+F8), and a Macro window will open.
➤ We have to click Run.
➤ Finally, we will see that all the hyperlinks in our Sheet4 are removed.
Read More: How to Remove Email Link in Excel (7 Quick Ways)
Conclusion
Here, we tried to show you some easy methods that will help you to remove Hyperlink in Excel Permanently. We hope you will find this article helpful. If you have any queries or suggestions, please feel free to know us in the comment section.
Related Articles
- 7 Solutions for Greyed Out Edit Links or Change Source Option in Excel
- How to Delete Hidden Link in Excel (5 Easy Ways)
- [Fix:] Edit Links in Excel Not Working
- [Solved]: Remove Hyperlink Not Showing in Excel (2 Solutions)
- Excel Hyperlink to Cell in Another Sheet with VLOOKUP (With Easy Steps)
- Remove Unknown Links in Excel (4 Suitable Examples)
- How to Find and Replace Hyperlinks in Excel (3 Quick Methods)
