Remove Hyperlinks in Excel

Article byJeevan A Y
Edited byAshish Kumar Srivastav
Reviewed byDheeraj Vaidya, CFA, FRM

If in our data any cells have values starting with https:// or www. it is considered a hyperlink. When we click on the cells, we are redirected to our browser regardless of whether the page exists. The method to remove hyperlinks in Excel is to select the cell or the column containing hyperlinks, right-click on it, and select the “Remove Hyperlinks” option.

How to Remove Hyperlinks in Excel?

Let us understand how to remove hyperlinks in Excel with examples.

You can download this Remove Hyperlinks in Excel Template here – Remove Hyperlinks in Excel Template

Hyperlinks are very powerful. It can take you to the desired location and shorten our time. However, if you already know how to insert hyperlinksHow To Insert HyperlinksTo insert a hyperlink, right-click on the cell, click on hyperlink, and then choose the last option, which will open a wizard box to insert a hyperlink. Then, in the field for an address, type the hyperlink's URL.read more, you must also know how to remove them.

We are telling this because Excel automatically creates a hyperlink when entering an email ID and URL. It will be very irritating to work with because every time you click on them, it will take you to their window and make you angry. (We get angry whenever it takes me to an outlook or web browser).

In these cases, we need to remove unwanted Excel hyperlinks automatically created by Excel when we insert an email ID or URL.

Method #1 – Remove Excel Hyperlink in Just a click

In this example, we are using three different types of hyperlinks. In column A, we have worksheet hyperlinks we have created. In the second column, we have the email IDs, and Excel itself creates hyperlinks. Finally,  have the website address in the third column, and Excel creates hyperlinks.

Below are the steps used to remove Excel hyperlinks in just a click:

  1. First, select the “Email ID” column.


    Remove Hyperlinks - step 1

  2. Right-click and select the “Remove Hyperlinks” option.


    Remove Hyperlinks - step 2

  3. It will instantly remove the hyperlinks in Excel and formatting.


    Remove Hyperlinks - step 3

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

There is an alternative method to remove the hyperlink in Excel.

Step 1: Select the targeted data first.

Remove Hyperlinks - step 4

Step 2: Then, on the “Home” tab, find the “Clear “button in the “Editing” group and click on the dropdown list.

Remove Hyperlinks - step 5

Step 3: This can also remove the hyperlink in Excel.

Remove Hyperlinks - step 6

Method #2 – Remove Hyperlink in Excel Using Find and Replace

We can also remove hyperlinks using “Find and Replace ExcelFind And Replace ExcelFind and Replace is an Excel feature that allows you to search for any text, numerical symbol, or special character not just in the current sheet but in the entire workbook. Ctrl+F is the shortcut for find, and Ctrl+H is the shortcut for find and replace.read more“. Follow the below steps.

Step 1: Press “Ctrl + F.”

remove hyperlinks - method 2- step 1

Step 2: Click on “Options.”

remove hyperlinks - method 2- step 2

Step 3: Now click on “Format” and select “Choose Format from Cell.”

remove hyperlinks - method 2- step 3

Step 4: Now, select the hyperlinked cell, showing the preview in blue.

remove hyperlinks - method 2- step 5

Step 5: Click on “Find All.” It will display all the hyperlinked cells.

remove hyperlinks - method 2- step 6

Step 6: Now, select those using the “Shift + Down Arrow” key.

remove hyperlinks - method 2- step 7

Step 7: Exit from the “Find & Replace” window.

Step 8: Now, all the hyperlinked cells are selected. Right-click and click on “Remove Hyperlinks.”

remove hyperlinks - method 2- step 8

Method #3 – Remove Hyperlink in Excel Using VBA Code

VBA code is the one-time code that we can regularly use whenever we want. VBA codeVBA CodeVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more instantly removes the hyperlink from the active sheet and the entire workbook.

Follow the below steps to start using it.

Step 1: Press the “Alt + F11” key to open the VBA editorVBA EditorThe Visual Basic for Applications Editor is a scripting interface. These scripts are primarily responsible for the creation and execution of macros in Microsoft software.read more window in the current worksheet.

remove hyperlinks - method 2- step 9

Step 2: Click on the “Insert” and insert “Module.”

remove hyperlinks - method 2- step 10

Step 3: Copy and paste the below code into the newly inserted module and click on “F5” to run the code.

The below code is to Remove hyperlinks from One Sheet at a time.

Sub Remove_Hyperlinks()

‘One sheet at a time

ActiveSheet.Hyperlinks.Delete

End Sub

remove hyperlinks - method 2- step 11

The below code is to Remove from the entire workbook.

Sub Remove_Hyperlinks1()

Dim Ws As Worksheet

For Each Ws In                      ActiveWorkbook.Worksheets

ActiveSheet.Hyperlinks.Delete

Next Ws

End Sub

remove hyperlinks - method 2- step 12

The first code will remove the hyperlink in the active sheet only. The second code will discard the hyperlink in the whole Excel workbook.

Run this code using the F5 key.

Note: Do not forget to save the workbook as a Macro-Enabled Workbook.

Excel automatically creates hyperlinks for email ID and URL.

Unfortunately, it is one of the irritating things to work with.

However, we can disable the hyperlink’s auto-creation option by changing the settings.

Restrict Excel from Creating Hyperlinks

Excel creates auto hyperlinks because there is a default setting to it. Email ID extensions and WWW web addresses are automatically converted to hyperlinks.

Follow the below steps to restrict Excel from creating auto hyperlinks.

Step 1: Click on the “File” option.

remove hyperlinks - method 2- step 14

Step 2: Now, click on “Options.”

remove hyperlinks - method 2- step 13

Step 3: Click on “Proofing” and “Autocorrect Options.”

remove hyperlinks - method 2- step 15

Step 4: Now, select “AutoFormatAutoFormatThe AutoFormat option in Excel is a unique way of formatting data quickly.read more As You Type”.

remove hyperlinks - method 2- step 16

Step 5: Uncheck the box: Internet and network paths with hyperlinks.

remove hyperlinks - method 2- step 17

Step 6: Click on “OK” and close this box.

Now, try adding a few email IDs and URL addresses.

Excel stops creating auto hyperlinks for emails and URLs.

Things to Remember

  • Excel auto hyperlinks for email and URL.
  • We must use a “Clear” hyperlink option to remove hyperlinks in Excel and retain formatting.
  • Changes the default settings to restrict Excel not to creating auto hyperlinks.
  • We can remove hyperlinks from the entire workbook by using the VBA code.

Recommended Articles

This article is a guide on how to remove Hyperlinks in Excel. Here, we discuss the three useful methods to remove hyperlinks in Excel, along with Excel examples and downloadable Excel templates. You may also look at these useful functions in Excel: –