Within your Excel spreadsheet, hyperlinks are an excellent way to connect to other files, websites, or email addresses.
However, there may be times when you need to remove hyperlinks in Excel. It could be because the link is invalid or you don’t need it.
This article teaches you how to remove hyperlinks in Excel. Also, you’ll learn an easy way to turn off automatic hyperlinks in Excel.
How to Remove Hyperlinks in Excel (2 Methods)
In this tutorial, I’m going to show you two easy ways to remove hyperlinks in Excel:
Note: The instructions in this article apply to Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.
Method 1: Remove a hyperlink from a single cell
- Select the cell that contains the hyperlink.
- Right-click the cell and select Remove Hyperlink.
It will remove the hyperlink from the cell, and the text will be as plain.
That’s it. You can remove hyperlinks in Word in a similar way.
RELATED: How to Remove Hyperlinks in Word
Method 2: Remove all hyperlinks from a range of cells
- Select the range of cells that contain the hyperlinks, or use Ctrl + A to select all cells.
- Right-click on any cell and click Remove Hyperlinks.
It will remove all the hyperlinks from your Excel spreadsheet.
Turn off Automatic Hyperlinks in Excel
If Excel is creating hyperlinks automatically, you can turn off this feature.
It will prevent Excel from creating hyperlinks whenever you type a URL or email address into a cell.
To prevent Excel from creating hyperlinks automatically, follow these steps:
- Inside the Excel spreadsheet, click File.
- Select Options at the bottom.
- In the Excel Options dialog box, select the Proofing tab.
- Select the AutoCorrect Options button.
- In the AutoCorrect dialog box, select the AutoFormat As You Type tab.
- Uncheck the “Internet and network paths with hyperlinks” box.
- Select OK to apply changes.
- Close the Excel Options window.
Once done, Microsoft Excel will no longer create hyperlinks when you type a URL or email address into a cell.
This setting will apply to the current and all spreadsheets you’ve created in the past.
Select a cell or range of cells with hyperlinks. From the Home tab, in the Editing group, click Clear > Clear Hyperlinks. It will display a small eraser icon (also called Clear Hyperlinks Options). Click on it and select Clear Hyperlinks Only from the drop-down. It will clear hyperlinks and keep formatting in Excel.