This is a simple way to find and delete Hyperlink in Excel

If spreadsheet Excel has many hyperlinks, then you want to remove these hyperlinks. However, with so many hyperlinks, removing hyperlinks will take a long time. So how to find and delete all hyperlinks on Excel file, please refer to the following article of Network Administrator.

1. Find and delete all Hyperlink on Excel

First select the cells you want to delete Hyperlink. To delete all available hyperlinks on the spreadsheet, press Ctrl + F to open the Find and Replace dialog box.

In the Find and Place dialog box, click the Options option .

Next click on the arrow at Format tab, select Choose Format from cell.

Select cell with hyperlink and it will display the preview next to the Format frame as shown below.

Click on Find All and all Excel hyperlinks will be displayed on the screen.

You can select one or more hyperlinks from the list of results using the Ctrl or Shift keys .

To delete hyperlinks, right-click on the hyperlink on the cell, then select Remove Hyperlink.

2. Find and delete Hyperlink on a specific text

Suppose to delete Hyperlink on Product 3, follow the steps below:

Press Ctrl + F to open the Find and Repalce dialog box.

In the Find what frame, enter Product 3 . Click on the down arrow next to Format, select 'Choose Format From Cell'.

Select the cell with Product 3 and it will show the preview next to the Format frame, then click Find all.

On the screen will display hyperlink Product 3.

Select the tape result by pressing Ctrl or Shift key. To delete all hyperlink, right-click the selected hyperlink and select Remove Hyperlinks .

3. Delete all hyperlinks at the same time

To delete all hyperlinks on spreadsheet Excel, press Ctrl + A or click on the triangle icon on the top of the sheet as shown below to select the entire spreadsheet.

Right-click anywhere on the sheet and select Remove Hyperlinks . All hyperlinks will be completely removed on the entire spreadsheet.

Refer to some of the following articles:

1. Summary of expensive shortcuts in Microsoft Excel

1. You want to print text, data in Microsoft Excel. Not as simple as Word or PDF! Read the following article!

1. These are the most basic functions in Excel that you need to understand

Good luck!