How to Remove Hyperlink Permanently in Excel (4 Ways)

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Remove Hyperlink Permanently in Excel: 4 Ways

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.

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 Unknown Links in Excel


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 External Links in Excel


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: 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

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 Delete Hidden Link in Excel


Download Workbook


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

<< Go Back To Remove Links in Excel | Linking in Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo