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.
There are 4 ways to remove Hyperlink from Excel in a permanent way. We’re going to show you that with the help of the following dataset that contains several Employee ID, Name and Email ID.
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 Unknown Links in Excel
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 External Links in Excel
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: How to Remove Email Link in Excel
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
'Code by Afia Aziz [email protected]
➤ 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 Delete Hidden Link in Excel
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.
- How to Remove Broken Links in Excel
- How to Remove Excel Links from Word Document
- [Solved]: Remove Hyperlink Not Showing in Excel