How to Quickly Find Hyperlinks in Excel (using Find and Replace)

Watch Video – How to Quickly Find Hyperlinks in Excel

If you have a lot of hyperlinks and these are scattered in the worksheet, it could be a herculean task to find these. Doing it manually can take you forever.

In this tutorial, you’ll learn how to quickly:

• Find all the hyperlinks in Excel.
• Find all the hyperlinks linked to a specific text.
• Delete All Hyperlinks at One Go.

Find All Hyperlinks in Excel

Suppose you have a dataset as shown below:

Using Find and Replace feature, you can quickly find all the hyperlinks and give you a list of cells that have it.

Here are the steps:

1. Go to Home –> Editing –> Find & Select –> Replace. This will open the Find and Replace dialog box (you can also use the keyboard shortcut Control + H).
2. In the Find and Replace dialog box, within the Replace tab, click on Options button. This would show you an additional set of options available to you.
3. In the Find what options, click on the small downward arrow on the Format button and select Choose Format From Cell.
4. Select any of the cells that has a hyperlink in it. This will populate the preview pane (on the left of the Format button) with the hyperlink format.
5. Click on Find All button. This will find all the cell with hyperlinks in it and show you a list as shown below.

You now have a list of all the hyperlinks. You can select each of these cells individually or hold the control key and select multiple cells from the list.

Also read: Extract URL from Hyperlinks in Excel

Find All Hyperlinks Linked to Specific Text in Excel

Suppose you have a dataset as shown below and you only want to find hyperlinks from the cells that have the text ‘Company A’ in it.

Here are the steps to do this:

1. Go to Home –> Editing –> Find & Select –> Replace. This will open the Find and Replace dialog box (you can also use the keyboard shortcut Control + H).
2. In the Find and Replace dialog box, within the Replace tab, click on Options button. This would show you an additional set of options available to you.
3. In the Find what field, enter ‘Company A’.
4. In the Find what options, click on the small downward arrow on the Format button and select Choose Format From Cell.
5. Select any of the cells that have the text ‘Company A’ and the hyperlink in it. This will populate the preview pane (on the left of the Format button) with the hyperlink format.
6. Click on Find All button. This will find all the cells that have the text ‘Company A’ and also have the hyperlinks as shown below.

You now have a list of all the hyperlinks. You can select each of these cells individually or hold the control key and select multiple cells from the list.

Delete All Hyperlinks at One Go

This one is easy.

To delete all hyperlinks at one go:

• Select the entire worksheet (click on the tilted triangle at the top left of the sheet or use the keyboard shortcut Control + A).
• Right-click anywhere in the worksheet and select the ‘Remove Hyperlinks’ options.

This would instantly remove all the hyperlinks in the worksheet.

You May Also Like the Following Excel Tutorials:

• Create Dynamic Hyperlinks in Excel.
• Get more out of Find and Replace in Excel (4 Amazing Tips).
• The Ultimate Guide to Find and Remove Duplicates in Excel.
• Remove Spaces in Excel – Leading, Trailing, and Double.
• Remove Hyperlinks in Excel.