Prevent Auto-Hyperlinking In Excel
By default Excel will convert text to a hyperlink if it determines your data is in a URL or email address format. This is typically not a wanted behavior inside spreadsheets and in this article you will learn a couple ways to prevent this type of auto-correction from occurring within Excel.
Below is an example of what you would see if you entered in text for search engine websites and email addresses.
The problem with these hyperlinks (and most likely why you are reading this article) is if you just want the data, it can be a pain to work around the links while making manipulations. In order to select a cell with a hyperlink, you need to use your right mouse button instead of your left.
So lets dive in and see how we can prevent this from occurring in the first place!
Excel-Level Change
First, let’s look at a setting we can tweak to change this auto-correction task across the entire Excel application. This means this change will impact every workbook on your machine.
In Excel >> File Tab >> Options Menu >>
- Select Proofing from the side-pane
- Click the AutoCorrect Options… button
- Navigate to the AutoFormat As You Type tab
- Uncheck Internet and network paths with hyperlinks under Replace as you type
- Click OK to confirm the change
Worksheet-Level Change
Now let’s take a look at how we can use VBA to prevent auto-hyperlinking at the worksheet level. The following code will use Excel Events to trigger the VBA. We will utilize the Change event to run this bit of code every time a cell’s value changes on the target worksheet. If you would like to learn more about triggering VBA code when something on the worksheet changes, you can read my more detailed blog post: How To Trigger Your VBA Macros To Run Based On A Specific Cell Value Change.
Preventing New Hyperlinks With VBA
The following snippet will need to be pasted inside your desired Sheet Object using the Visual Basic Editor. It will look at only the range of cells that were last changed and remove any hyperlinks located within that range.
Private Sub Worksheet_Change(ByVal Target As Range)
'PURPOSE: Prevent any new hyperlinks from auto-generating
'NOTE: Manually adding hyperlinks can still be done
If Target.Hyperlinks.Count <> 0 Then Target.Range.ClearHyperlinks
End SubPreventing Any Hyperlinks With VBA
If you absolutely don’t want to have any hyperlinks on your sheet, we can use a more encompassing piece of code. The following VBA subroutine will need to be pasted inside your desired Sheet Object using the Visual Basic Editor. This code will remove any hyperlinks on the spreadsheet when a change is made.
Private Sub Worksheet_Change(ByVal Target As Range)
'PURPOSE: Prevent any hyperlinks ever occuring within this spreadsheet
'Remove All Hyperlinks From Cells In This Sheet
Me.Cells.ClearHyperlinks
End SubAny Other Solutions?
Have your discovered any other methods we can take inside Excel to prevent hyperlinks? Let me know in the comments section below.
Learn my best Excel chart design hacks. These will turn your ugly charts into professionally crafted graphics, leaving your boss speechless!!!
Keep Learning
![4 PRO Ways to Create A Filtering Search Box [Excel Download]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/ExcelFilteringSearchBox.png)
Chris Newman
Chris is a finance professional and Excel MVP recognized by Microsoft since 2016. With his expertise, he founded TheSpreadsheetGuru blog to help fellow Excel users, where he shares his vast creative solutions & expertise. In addition, he has developed over 7 widely-used Excel Add-ins that have been embraced by individuals and companies worldwide.