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.

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.

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:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

2 thoughts on “How to Quickly Find Hyperlinks in Excel (using Find and Replace)”

  1. The tip above, in a find’n’replace scenario, as far as I can tell, only changes the ‘Description’ of the URL, not the target.
    I’ve created 6 test cases, and only the ones in which the display matches the find what: or hyperlink formatting actually changes.
    The target url is not updated.

    Reply

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster