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:

Find and Remove Hyperlinks in Excel - Numbers

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).Find and Remove Hyperlinks in Excel - Replace click
  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.Find and Remove Hyperlinks in Excel - Options
  3. In the Find what options, click on the small downward arrow on the Format button and select Choose Format From Cell.Find and Remove Hyperlinks in Excel - Numbers choose format
  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.Find and Remove Hyperlinks in Excel - find preview
  5. Click on Find All button. This will find all the cell with hyperlinks in it and show you a list as shown below.Find and Remove Hyperlinks in Excel - number find all

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.

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.

Find and Remove Hyperlinks in Excel - Company Data

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).Find and Remove Hyperlinks in Excel - Replace click
  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.Find and Remove Hyperlinks in Excel - Options
  3. In the Find what field, enter ‘Company A’.Find and Remove Hyperlinks in Excel - find What field
  4. In the Find what options, click on the small downward arrow on the Format button and select Choose Format From Cell.Find and Remove Hyperlinks in Excel - Company A Choose Format
  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.Find and Remove Hyperlinks in Excel - Company A Preview
  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.Find and Remove Hyperlinks in Excel - Company A Find List

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).Find and Remove Hyperlinks in Excel - Select All
  • Right-click anywhere in the worksheet and select the ‘Remove Hyperlinks’ options.Find and Remove Hyperlinks in Excel - Remove Hyperlinks

This would instantly remove all the hyperlinks in the worksheet.

You May Also Like the Following Excel Tutorials:

  • Brian Canes says:

    In the VBE immediate window
    Activesheet.hyperlinks.delete
    Regards
    Brian

  • >