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.

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: 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.

Here are the steps to do this: 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.

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.

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.