[Fixed!] Excel Hyperlink Keeps Coming Back (5 Quick Solutions)

Get FREE Advanced Excel Exercises with Solutions!

A hyperlink is a form of text that refers to a certain web address with a URL link. Microsoft Excel allows us to auto-hyperlink any text whenever we type it in a cell. Sometimes we want to omit this feature but in Excel, the hyperlink keeps coming back. In this article, we will discuss 5 quick solutions when hyperlink keeps coming back in Excel.


When Hyperlink Keeps Coming Back in Excel: 5 Quick Solutions

To illustrate the solutions, we created a sample dataset. Here, we have a list of the Top 5 Sites of 2022 with Site Names and Site Addresses in the cell range B5:C9. As you can see, the site addresses are hyperlinked automatically after typing each name.

Excel Hyperlink Keeps Coming Back


To solve this, apply any of the methods below to prevent the return of hyperlinks.

1. Apply Autocorrect Option to Prevent Auto Hyperlink in Excel

You can use the Autocorrect feature in Excel when the hyperlink keeps coming back. To conduct this, follow the steps below.

  • First, go to the File tab of your workbook.

Apply Autocorrect Option to Prevent Auto Hyperlink in Excel

  • Then, select Options on the Backstage View.

  • Following, go to the Proofing section in the Excel Options dialogue box.
  • Here, select AutoCorrect Options.

Apply Autocorrect Option to Prevent Auto Hyperlink in Excel

  • Next, click on AutoFormat As You Type in the AutoCorrect window.
  • In this window, deselect Internet and network paths with hyperlinks.

Apply Autocorrect Option to Prevent Auto Hyperlink in Excel

  • Lastly, press OK twice to close all the windows.
  • Finally, type the web address again and you will see no hyperlink is generated automatically.

Read More: How to Edit Hyperlink in Excel


2. Insert Excel VBA to Stop Return of Hyperlink

You can eliminate hyperlinks with VBA Macro code as well. Let’s see how it works.

  • In the beginning, go to the Developer tab and select Visual Basic from the Code group.

Insert Excel VBA to Stop Return of Hyperlink

  • Then, select Module from the Insert tab in the Visual Basic Editor window.

  • Next, type this code on the blank page.
Sub EraseAllHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

Insert Excel VBA to Stop Return of Hyperlink

  • Afterward, click on Run Sub/UserForm in the Run tab or press F5 on your keyboard.

  • Following, click on Run in the Macro window.

  • Finally, all the hyperlinks will be erased like this.

Excel Hyperlink Keeps Coming Back

  • As you have the VBA code saved for this specific workbook, whenever you want to remove the hyperlink, click on the Macros icon and run the code without typing the code every time.

Read More: How to Fix Broken Hyperlinks in Excel


3. Use Paste Special Feature to Remove Hyperlink in Excel

In this section, we will apply the Paste Special feature of Excel to remove hyperlinks and prevent them from returning.

  • First, type 1 in any blank cell adjacent to your dataset.
  • For example, we typed 1 in Cell C10.

Use Paste Special Feature to Remove Hyperlink in Excel

  • Then, select the cell and press Ctrl + C to copy it.
  • Following, select the cell range C5:C9 as they are the hyperlinked cells.

  • Next, right-click on any of the selected cells.
  • Then, select Paste Special.

Use Paste Special Feature to Remove Hyperlink in Excel

  • Afterward, select Multiply in the Operation section of the Paste Special dialogue box.

Use Paste Special Feature to Remove Hyperlink in Excel

  • Finally, press OK and you will see all the hyperlinks are removed successfully.

Read More: How to Find and Replace Hyperlinks in Excel


4. Eliminate Hyperlink Permanently from Context Menu

We can prevent hyperlinks from coming back with just two clicks. Let’s see the process below.

  • First, select the cell range C5:C9 as they contain the hyperlinks.

Eliminate Hyperlink Permanently from Context Menu

  • Then, right-click on any of the cells and click on Remove Hyperlinks from its Context Menu.

  • That’s it, the hyperlinks are not visible anymore.

Read More: How to Extract Hyperlink from URL in Excel


5. Apply Keyboard Shortcuts to Stop Coming Back Hyperlink

Here is a quick solution to eliminate hyperlinks with keyboard shortcuts. Let’s see how it works.

  • First, type the first website address in Cell C5.
  • Then, press Enter.
  • Afterward, you will the text is hyperlinked like this.

Apply Keyboard Shortcuts to Stop Coming Back Hyperlink

  • Therefore, immediately press Ctrl + Z on your keyboard.
  • That’s it, the site address will return to normal text just the way you typed it.

  • Follow, the same procedure to get all the site addresses without hyperlinks.


Download Practice Workbook

Download this sample file and practice by yourself.


Conclusion

Henceforth, we are at the conclusion of our tutorial. Here, we tried to guide you with 5 solutions when hyperlink keeps coming back in Excel. Let us know if you can suggest any other method to solve this issue.


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.
Sanjida Mehrun Guria
Sanjida Mehrun Guria

Hello! Welcome to my blog. I have completed my Bachelor in Architecture from Ashanullah University of Science & Technology, Dhaka. I am a passionate, goal-oriented person with an immense thirst for knowledge and an attitude to grow continuously. Besides Architectural work, I find it very enthusiastic to work in Excel blogging. Exceldemy is a platform where I have got the opportunity to flourish my skill in Microsoft Excel and therefore, here I will be posting blogs related to it.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo