How to Remove Hyperlinks in Excel? 3 Easy Methods

Note: This tutorial on how to remove hyperlinks in Excel is suitable for all Excel versions including Office 365. 

The hyperlink is no doubt a very useful feature. It enables us to easily redirect to other resources simply by clicking on them. These resources can range from web pages, local documents, or other online content.  

But, unnecessary usage of hyperlinks can be very irritating. It will create a lot of clutter and confusion if overused. 

Unfortunately, Excel automatically converts all URLs or e-mail addresses into clickable hyperlinks by default. This can become very frustrating in the long run, especially if you need to keep your data clean and organised. 

In this guide, I’ll teach you how to remove hyperlinks in Excel like a pro and help you save precious time. 

You can download the free sample Excel Sheet here and follow along with this guide.

Related:

How to Use the Format Painter Excel Feature? — 3 Bonus Tips

How to Indent in Excel? 3 Easy Methods

How to Add Subscript in Excel? (6 Best Methods)

Disable Automatic Hyperlink in Excel

Prevention is always better than cure. First, I’ll show you how to avoid this hyperlink mess in the first place. Please follow these steps: 

1. Go to the File tab and click on Options. This will open the Excel Options window. You can also use the keyboard shortcuts Alt+T+O or Alt+F+T to directly open the Excel options window.

2. Under Excel Options, open the Proofing tab and click on the AutoCorrect Options button inside it. 

3. In the AutoCorrect Options window, deselect the Internet and network paths with hyperlinks option under the AutoFormat as you type tab. 

4. Click OK to save your changes and exit the window. 

As soon as you do this, Excel will no longer convert URLs or internet addresses to hyperlinks. 

In case you need to add hyperlinks, select the text or object and press Ctrl+K to add them. 

Also Read:

How to Apply the Accounting Number Format in Excel? (3 Best methods)

How to Enable Excel Dark Mode? 3 Simple Steps

The FORMULATEXT Excel Function – 2 Best Examples

How to Remove Hyperlinks in Excel in One Go?

If you are using any version later than Excel 2010, you can easily remove multiple or all hyperlinks in one go. 

All you need to do is select the range of cells that contain the hyperlinks. You can select the entire sheet using Ctrl+A or even multiple worksheets at a time. 

Then, right-click anywhere inside the selected cells and choose the Remove Hyperlinks option from the Context menu. You can access this menu by using the shortcut Shift+F10. 

Or click on the Clear option under the Editing group of the Home tab. In the drop-down menu choose Remove Hyperlinks. 

This will remove all the hyperlinks in your selection in one go. 

How to Remove Hyperlinks in Excel Using VBA Code

Let us say, you are using an older version of Excel. Or you are simply tired of using the right-click context menu, as there may be too many hyperlinks in your workbook. 

How to remove hyperlink in Excel with a single button click?

Fortunately, VBA codes come to our rescue. 

Hit Alt+F11 to open your VBA editor. 

Now, in the Project Window displayed on the left-hand side of the VBA editor, double-click on ThisWorkbook. 

Next, in the Module window copy and paste the following VBA code:

' VBA Code to Remove all Hyperlinks in Excel
Sub RemoveAllHyperlinks()
Dim Ws As Worksheet
On Error Resume Next
For Each Ws In ActiveWorkbook.Worksheets
      Ws.Hyperlinks.Delete
      Next Ws
End Sub

Then, hit F5 to run the VBA code module. 

This will remove all the hyperlinks in your workbook in one go. You no longer need to worry about them. But, keep in mind that this action is irreversible. You cannot undo the removal of hyperlinks using Ctrl+Z. 

Let me share an interesting tip with you. 

You can actually save this VBA code as an easy-to-use, click and forget button on your Quick Access toolbar. Just follow these instructions: 

1. Once you have added the VBA code module, close the VBA editor window. 

2. Click on the Customize Quick Access Toolbar button and choose More Commands

3.  In the Excel Options window, under the Choose commands from the drop-down list, select Macros. 

4. Now scroll down and select the VBA code module that we just added. 

5. Click on Add and click OK. 

That’s all. A quick-access button for running this VBA code will be added to the Quick Access toolbar. 

You can save your Worksheet as a macro-enabled workbook and keep using this ready-made button for quickly removing all hyperlinks. 

Suggested Reads:

How to Autofit Excel Cells? 3 Best Methods

How to Extract an Excel Substring? – 6 Best Methods

How to Shade Every Other Row in Excel? (5 Best Methods)

FAQs

How do I remove hyperlinks in Excel without losing formatting?

To clear hyperlinks without changing format settings, first select the cell or range of cells that contain the hyperlinks. Then, click on the Clear option in the Editing group of the Home Tab.
Now, select the Clear Hyperlinks option under the drop-down list. This will display a small pink-colour eraser at the right bottom of your selection. Click on it and choose Clear Hyperlinks Only to clear hyperlinks but keep the formatting.

How to remove multiple hyperlinks in excel?

If you have multiple hyperlinks spread over multiple sheets, the best way to clear them all is to run the following VBA code in the VBA editor.

‘ VBA Code to Remove all Hyperlinks in Excel
Sub RemoveAllHyperlinks()
Dim Ws As Worksheet
On Error Resume Next
For Each Ws In ActiveWorkbook.Worksheets
Ws.Hyperlinks.Delete
Next Ws
End Sub

Let’s Wrap Up

In this guide, we saw how to remove hyperlinks in Excel the easy way. I also talked about how to avoid them in the first place. I hope this will make your work less stressful and more fun. 

If you have any questions about this or any other Excel feature, please feel free to ask in the comments section. 

Need more high-quality Excel guides? Check out our free Excel resources centre.

Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses by seasoned professionals. Click here for advanced Excel courses with in-depth training modules.

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats.When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.