A hyperlink in Excel will help you to connect cells in your worksheet to other content. That might be to another sheet, a specific cell, or even an external page like a website.
Hyperlinks are a helpful feature, but you might also need to remove and clear them from your workbook. Let’s learn how to do just that as we learn how to clear hyperlinks in Excel.
How to Clear Hyperlinks in Excel
First, let’s have a quick review of how hyperlinks in Excel work. On the Insert tab, you’ll see a button called Link in a section called Links. When you click on this option, you’ll open a menu to set a link to any of the available options like another spreadsheet or external website.
After you add your hyperlink, you’ll see it in the spreadsheet and the cell becomes clickable. When you click on it, Excel will send you to the location of the link.
To clear a link, click in the cell, and then find the Editing section on the Home tab on Excel’s ribbon. Click on the Clear dropdown, then choose Remove Hyperlinks.
You might be wondering about the Clear Hyperlinks option on this menu. This option doesn’t remove the link functionality, but it does remove the formatting. That means that the link still takes the user to another spreadsheet or website, but the cell will look normal (and won’t feature an underline or specific text color.)
If you want to remove all hyperlinks in a specific spreadsheet, start by selecting all cells with Ctrl + A on Windows, or Cmd + A on macOS. Then, repeat the same steps. This time, Excel removes all active hyperlinks in your selection. You’ll need to repeat these steps on each sheet to clear all the hyperlinks in your workbook.