Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Remove Hyperlink Permanently in Excel (4 Ways)

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.

Hyperlink in Excel


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.

Remove Hyperlink option to Remove Hyperlink in cell D9

➤ Finally, we will see that the Hyperlink in cell D9 is removed.

Cell D9 Hyperlink Remoe in Excel Permanently

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.

Hyperlink removed for Multiple cells in Excel Permsnently

Read More: How to Remove All Hyperlinks in Excel (5 Methods)


Similar Readings


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.

Remove Hyperlink in Excel Permanently by Preventing Auto hyperlinking

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

VBA Code to Remove Hyperlink in Excel Permanently

➤ 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.

Remove Hyperlink in Excel Permanently using VBA Code

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

Afia Kona

Afia Kona

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo