If in our data any cells have values starting with https:// or www. it is considered to be an hyperlink, when we click on the cells we are redirected to our browser regardless the page exists or not, the method to remove hyperlinks in excel is to select the cell or the column containing hyperlinks and right-click on it and select remove hyperlinks option.
Table of Contents
- How to Remove Hyperlinks in Excel?
- Method #1
- Method #2
- Method #3
- Restrict Excel from Creating Hyperlinks
How to Remove Hyperlinks in Excel?
Let’s understand how to remove hyperlinks in excel with examples.
Hyperlinks are very powerful. It will take you to the desired location and shorten our time. If you already know how to insert hyperlinks then you must know how to remove them as well.
The reason why I am telling this because when we enter an email id, URL, Excel automatically creates a hyperlink to it. It will be very irritating to work with because every time you click on them it will take you to their window and makes you angry. (I get angry every time it takes me to outlook or web browser).
In these cases, we need to remove unwanted hyperlinks in excel that are automatically created by excel when you enter an email id or URL.
Method #1 – Remove Excel Hyperlink in Just a click
In this example, I am using 3 different types of hyperlinks. In the column A I have worksheet hyperlinks I have created, in the second column I have email id’s and hyperlinks are created by excel itself and in the third column I have the website address and hyperlinks are created by excel itself.
Step 1: Select the email id column.
Step 2: Right click and select “Remove Hyperlinks” option.
Step 3: This will instantly remove the hyperlinks in Excel as well as formatting.
Alternative Method to Remove Hyperlinks in Excel
There is an alternative method to remove the hyperlink in excel.
Step 1: Select the targeted data.
Step 2: On the Home, tab finds the Clear button in the editing group and click on the drop-down list.
Step 3: This will remove the hyperlink in excel as well.
Method #2 – Remove Hyperlink in Excel Using Find and Replace
We can also remove hyperlinks using Find and Replace Excel. Follow the below steps.
Step 1: Press Ctrl + F
Step 2: Click on Options.
Step 3: Now click on Format and select Choose Format from Cell.
Step 4: Now select the hyperlinked cell and it will show the preview in blue colour.
Step 5: Click on Find All and it will display all the hyperlinked cells.
Step 6: Now select all those by using Shift + Down Arrow.
Step 7: Exit from the Find & Replace window.
Step 8: Now all the hyperlinked cells are selected. Right click and click on Remove Hyperlinks.
Method #3 – Remove Hyperlink in Excel Using VBA Code
VBA code is the one time code that we can use regularly whenever we want. VBA code instantly removes the hyperlink not only from the active sheet rather from the entire workbook itself.
Follow below steps to start using it.
Step 1: In the current worksheet press Alt + F11, this will open up the VBA editor window.
Step 2: Click on insert and insert module.
Step 3: Copy and paste the below code in the newly inserted module and click on F5 to run the code.
Below code is to Remove hyperlinks from One Sheet at a time.
‘One sheet at a time
Below code is to Remove from the entire workbook.
Dim Ws As Worksheet
For Each Ws In ActiveWorkbook.Worksheets
The first code will remove the hyperlink in the active sheet only. Second code will remove the hyperlink in the entire Excel workbook.
Run this code using the F5 key.
Note: Do not forget to save the workbook as Macro-Enabled Workbook.
Excel automatically creates hyperlinks for email id, URL. This is one of the irritating things to work with.
However, we can disable that option of auto-creation of the hyperlink by changing the settings.
Restrict Excel from Creating Hyperlinks
The reason why 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 File option.
Step 2: Now click on Options.
Step 3: Click on Proofing and Autocorrect Options
Step 4: Now select AutoFormat as you type.
Step 5: Uncheck the box: Internet and network paths with hyperlinks.
Step 6: Click on OK and close this box.
Now, try adding few email ids and URL addresses.
Excel stops creating auto hyperlinks for Email and URLs.
Things to Remember
- Excel auto hyperlinks for Email and URL.
- Use a clear hyperlink option to remove hyperlinks in excel and retain formatting.
- Changes the default settings to restrict excel to not create auto hyperlinks.
- We can remove hyperlinks from the entire workbook by using VBA code.
This has been a guide on how to remove Hyperlinks in Excel. Here we discuss the 3 useful methods to remove hyperlinks in excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –