By the end of this article, you will learn

How to find and remove all hyperlinks in ExcelHow to find and remove hyperlinks with specific text andDelete all hyperlinks at one go.

So, without any ado let us jump into it.

Select the cells from which you want to remove hyperlinks. Say I have the sample data of 10 websites with links to a few websites. Now, I want to remove all the hyperlinks available in the spreadsheet. To do so, I will press “CTRL+F” on my keyboard and it will open up the ‘Find and Replace’ dialog box. Click on ‘Options’ button present at the bottom.

Now, click on down arrow present with “Format” button and select “Choose Format From Cell”.

Select the cell which has a hyperlink and it will show the preview (left to the Format button) that has the hyperlink format.

Click on “Find All” button and it will show you all hyperlinks in Excel.

You can select one or more hyperlinks from the result using CTRL or Shift buttons. To remove them right click on the cells highlighted and select “Remove Hyperlinks”.

Find and Remove Hyperlinks with Specific Text

In this section, we will see how to remove hyperlinks in Excel associated with the specific text. Say, I have the sample data of products and some of the products were linked more than once. So, if I want to hyperlinks which have the text ‘Product 3’. Here how it is done. Press “CTRL+F” and it will open “Find and Replace” dialog box.

In “Find what” text box type the text “Product 3”. Click on the down arrow of the “Format” button and choose “Choose Format From Cell”.

Select the cell which has “Product 3” and it will show the preview (left to the Format button) and click on “Find All” button. It will display the list of hyperlinks with Product 3.

Select the result by holding Ctrl or Shift button. To remove them right click on the cells highlighted and select “Remove Hyperlinks”.

To delete all hyperlinks in Excel spreadsheet, then press CTRL+A or click on the triangle present on the top of the sheet to select the entire spreadsheet.

Now, right click anywhere on the sheet and select “Remove Hyperlinks”. This will remove all hyperlinks present in an entire spreadsheet.

This is the simple way to find and remove hyperlinks in Excel.

It is possible to remove all hyperlinks from an Excel spreadsheet. Whether you use Excel Online or the desktop app, you can do it on either app. To mass remove hyperlinks in Excel, you need to right-click on the icon, which lets you select the entire spreadsheet and select the Remove Hyperlinks option.

To find hyperlinks in an Excel spreadsheet, you can follow the aforementioned guide. You need to press Ctrl+F and click the Options button. Then, click on the Format arrow icon and select the Choose Format From Cell option. Then, click on the hyperlink cell. It will select the hyperlinks at once. Have a look at Advanced Excel Tips and Tricks to get the best out of Excel.