How to find and delete hyperlinks in Microsoft Excel

Do you have a huge Excel worksheet with tons of hyperlinks and you just don't have the time to sit down and find each one manually? Or do you want to find all hyperlinks in an Excel worksheet based on some text criteria? Or, do you just want to delete all hyperlinks in your Excel worksheet at once? Well, this Geek Page article is the answer to all your questions.

Read on to learn how to find, list and delete hyperlinks in Excel worksheets with or without any standards. So, what are you waiting for, let’s dive into the article without wasting time!

Part 1: How to Find, List and Delete Hyperlinks

Step 1: Open the Excel worksheet with the hyperlinks and press at the same time The CTRL F key opens the Find and Replace window.

In the Find and Replace window, you will automatically be on the Findtab. Click the Options > > button.

Step 2: Now, click on the drop-down arrow icon of the "Format" button, Then click the "Select format from cell" option in the drop-down list.

Step 3: You now have the option to select a cell from the Excel worksheet. Click the cell that contains the hyperlink. This is to capture the format of the hyperlink.

After clicking on the cell, click the "Find All" button in the "Find and Replace" window.

Step 4: The Find and Replace window will now list all the hyperlinks that exist in the Excel worksheet. If you click an entry in the Find and Replace window, it will automatically be highlighted on the Excel worksheet.

Step 5: If you want to select all hyperlinks and delete them all at once, press the SHIFT key and then click Click the first entry in the Find and Replace window, and then click the last entry. This will select all entries listed by the Find and Replace function.

NOTE: If you only want to delete a specific hyperlink, just do this from the Find and Replace window FindResults" to select these entries.

Step 6: Now, on the Excel worksheet, right-click anywhere in the selected range of cells and select from the right-click context menu Click on the "Remove Hyperlink" option.

Step 7: That’s it. The hyperlink will now be removed successfully.

Section 2: How to Find, List and Delete Hyperlinks Based on Text Conditions

Now suppose you want to delete hyperlinks that contain only specific text in them . In the example below, I want to remove all hyperlinks that have the text Excel in them so that all Excel article hyperlinks are removed from my Excel sheet.

Step 1: Just like the section above, just press the CTRL F key to launch the Find and Replace window.

Next click the Options > > button.

Step 2: Next, click the drop-down arrow of the "Format" button, Then click on the "Select format from cell" option.

Step 3: Next, click any cell that contains a hyperlink. Now in the Find and Replace window, under the Find what field, enter the word based on which you want to filter the hyperlinks.

In the example below, I want to remove hyperlinks from cells containing the word Excel. So I entered Excel under the Find what field.

Now click the Find All button.

Step 4: This will list only cells that contain Hyperlink and contain the Excel word. You can find and Select all cells in the "Replace " window. Note: This step is basically to select cells based on two conditions, that is, there should be a hyperlink in the cell, and the text within the cell should have what we have in Find the word specified in the what

field. Only cells will be selected if both conditions are met.

Step 5

: Now on the Excel worksheet, right-click

anywhere in the selected cell range, Then click on the "

Remove Hyperlink" option from the right-click context menu.

Step 6

: That’s it. The hyperlinks of all cells containing the word Excel have now been successfully removed from the Excel worksheet.

Section 3: How to delete all hyperlinks from Excel worksheet in two steps

If you want to delete all from Excel worksheet at once Hyperlinks without worrying about listing or filtering them, you can do that with the help of the following 2 steps.

Step 1

: First, click the

Select All icon with the downward arrow at the top of the Excel worksheet, located at the intersection of the column labels and row labels.

This will select your entire Excel worksheet.

Step 2

: Nowright-click the

"Select all

" button and click "Delete hyperlink" option. This will delete all hyperlinks present in the worksheet at once! enjoy!

The above is the detailed content of How to find and delete hyperlinks in Microsoft Excel. For more information, please follow other related articles on the PHP Chinese website!