How to Delete Hidden Link in Excel (5 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working with Excel, you may want to remove unwanted links from your spreadsheet. Now, in this article, we’ll show 5 effective ways how to delete hidden link in Excel. In the following sections, we’ll explore how to utilize Excel’s built-in options and VBA code to get rid of hyperlinks. In addition, we’ll also see how to disable automatic link insertion.


How to Delete Hidden Link in Excel: 5 Ways

Excel instantly creates a clickable hyperlink whenever you enter an email address or URL in a cell. However, I find this feature to be a nuisance rather than beneficial hence, without further delay, let’s see each of the methods to eliminate hidden links.


Method-1: Using the Remove Hyperlink Option

We’ll begin with the simplest and most trendy way to remove hyperlinks; simply, we’ll use Excel’s built-in Remove Hyperlink option. So, let’s see it in action.
Considering the List of Clients dataset shown in the B4:C13 cells. Here, the dataset shows the Names of the clients and their Email addresses respectively.

how to delete hidden link in excel

Here, we have used Microsoft Excel 365 version, you may use any other version according to your convenience.


1.1 Removing Single Hyperlink

If you want to remove a single hyperlink within a cell, you can follow the steps shown below.

📌 Steps:

  • In the first place, go to the cell from which you want to remove the hyperlink. For example, we’ve chosen the C5 cell.
  • Now, Right-click on the mouse to bring up the Shortcut Menu >> choose the Remove Hyperlinks option.

Removing Single Hyperlink

That’s it, you’ve removed the hyperlink from the C5 cell. It’s that simple.

how to delete hidden link in excel Using Remove Hyperlinks Option


1.2 Removing Multiple Hyperlinks

Luckily, you may apply the previous method to remove hyperlinks from a range of cells, hence, let us see the process in detail.

📌 Steps:

  • To begin with, select the C5:C13 cells >> Right-click the mouse to open the Shortcut Menu >> choose the Remove Hyperlinks option.

Removing Multiple Hyperlinks

After completing the step, all the hyperlinks should be gone, as shown in the image below.

how to delete hidden link in excel Using Remove Hyperlinks Option for multiple cells

Read More: How to Remove Hyperlink Permanently in Excel


Method-2: Utilizing Paste Special Option

Another handy way to eliminate hyperlinks in Excel involves using the Paste Special feature. The process is simple and easy, therefore, just follow along.

📌 Steps:

  • First and foremost, type 1 in the adjacent E5 cell >> press the CTRL + C keys.

Utilizing Paste Special Option

  • Next, select the C5:C13 cells >> hit the CTRL + ALT + V keys on your keyboard.

Using Paste Special

Now, this opens the Paste Special wizard.

  • Then, select the Multiply option >> click the OK button.

Select Multiply Option

Finally, your result should look like the picture shown below.

how to delete hidden link in excel using paste special option

Read More: How to Remove Unknown Links in Excel


Method-3: Pasting Links as Values

For our third method, we’ll apply the Paste Values option to remove hyperlinks from multiple cells at once. So, let’s have a look at the process in the steps below.

📌 Steps:

  • Initially, choose the C5:C13 range of cells >> hit the CTRL + C keys.

Pasting Links as Values

  • Then, navigate to the E5 cell >> click the Paste drop-down >> from the list, choose the Paste Values option.

using paste values option

  • Following this, select the E5:E13 cells >> type in CTRL + X.

cutting with keyboard shortcut

  • In turn, paste these values into the C5:C13 range using the CTRL + V keys.

pasting with keyboard shortcut

Lastly, your output should look like the screenshot shown below.

how to delete hidden link in excel using paste values option

Read More: How to Remove External Links in Excel


Method-4: Employing Edit Links Option

Sometimes your spreadsheet may have hidden links to another workbook located on your PC. This is an external link that you can clear away using the edit Links option.

📌 Steps:

  • First, move to the Data tab >> in the Queries & Connections group, and click the Edit Links option.

Employing Edit Links Option

Now, this opens the Edit Links dialog box.

  • Second, click the Break Link button to sever the connection between the two spreadsheets.

how to delete hidden link in excel Breaking Links

As a note, a warning will pop up that you cannot undo this process.

  • Now, click the Break Links button to confirm.

how to delete hidden link in excel

  • Third, select the C5:C13 cells >> Right-click the mouse >> press the Remove Hyperlinks option.

using remove hyperlinks option

Eventually, the results should look like the image given below.

how to delete hidden link in excel with edit links option

That said, however, the world we live in is far from perfect! At times, the Edit Links option may be greyed out, so if you wish, you can explore this article for fixing Edit Links.

Read More: How to Remove Email Link in Excel


Method-5: Applying VBA Code

If you have multiple worksheets, and you often need to remove hyperlinks from them, then you may consider the VBA Code below. Now, allow me to demonstrate the process in the straps below.

📌 Steps:

  • At the very beginning, proceed to the Developer tab >> click the Visual Basic button.

 Applying VBA Code

Now, this opens the Visual Basic Editor in a new window.

  • Second, go to the Insert tab >> select Module.

inserting module

For your ease of reference, you can copy the code from here and paste it into the window as shown below.

Sub Delete_All_HyperLinks()

Dim Wrk_Sht As Worksheet

For Each Wrk_Sht In Worksheets
    Wrk_Sht.Cells.Hyperlinks.Delete
Next Wrk_Sht

End Sub

VBA Code

âš¡ Code Breakdown:

Now, I will explain the VBA code for removing hyperlinks. In this case, the code is divided into 2 steps.

  • In the first portion, the sub-routine is given a name, here it is Delete_All_Hyperlinks().
  • Next, define the variable Wrk_sht and assign the Worksheet object to it.
  • In the second potion, use the For-Next statement to loop through all the worksheets and apply the Hyperlink.Delete method to clear away all the hyperlinks.

how to delete hidden link in excel Code explanation

  • Third, close the VBA window >> click the Macros button.

This opens the Macros dialog box.

  • Following this, select the Delete_All_Hyperlinks Macro >> hit the Run button.

running vba code

Subsequently, the results should look like the screenshot given below.

how to delete hidden link in excel with VBA Code


How to Switch Off Automatic Insertion of Hyperlinks

If you’re wondering if there is a way to switch off the auto insertion of hyperlinks, Lucky you! Our next section answers this exact question. So, let’s see it in action.

📌 Steps:

  • To start, jump to the File tab, in the top-left corner.

Switch-off Automatic Insertion of Hyperlinks

  • Next, click the Options button at the bottom.

Excel Options

In an instant, the Excel Options window pops up.

  • Then, click on the Proofing tab >> click the AutoCorrect Options.

Proofing tab

  • In turn, select the AutoFormat As You Type tab >> uncheck the Internet and network paths with hyperlinks option >> press the OK button.

how to delete hidden link in excel with Excel options

After completing the above steps, the auto insertion of hyperlinks will be disabled.


How to Break Links in Excel and Keep Values

You can break an external link to a different workbook using the Edit Link option. So just follow along.

📌 Steps:

  • In the first place, navigate to the Data tab >> click the Edit Links option.

How to Break Links in Excel and Keep Values

This brings up the Edit Links wizard.

  • Now, click the Break Link button to detach the links between the two workbooks.

Edit links

  • Next, select the C5:C13 cells >> Right-click on the mouse >> choose Remove Hyperlinks option.

remove hyperlinks option

Consequently, this should return output, as shown in the screenshot below.

how to delete hidden link in excel with Edit Links feature


Download Practice Workbook

You can download the practice workbook from the link below.


Conclusion

This article provides the answers on how to delete a hidden link in Excel quickly and easily. Make sure to download the practice files. Hope you find it helpful. Please inform us in the comment section about your experience. We are happy to answer your queries. Keep learning and keep growing!


Related Articles

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Eshrak Kader
Eshrak Kader

Hello! Welcome to my Profile. I completed my BSc. at Bangladesh University of Engineering & Technology from the Department of Naval Architecture & Marine Engineering. Currently, I am conducting research & posting articles related to Microsoft Excel. I am passionate about research & development and finding innovative solutions to problems.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo