DEV Community

loading...

How to Find and Break Broken Links in Excel Office 365?

excelgeek profile image Andrews Originally published at geekexcel.com on ・3 min read

In this article, we are going to see how to Find and Break Broken Links in Excel Office 365 with Kutools. Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

List All Links in a List to Find & Navigate Between Cells with Links:

To list all links of the workbook in a list, follow the below steps.

  • First, you need to open the workbook that has a list of links.
  • Go to the Kutools Tab, select the Link option, then choose the *Find and Break Broken Links * option.

Kutools Tab
Kutools Tab

  • It will display the Find and Break Broken Links Dialog Box.
  • View Cell – If this option is selected, you can click on the link to find and navigate to the specific cell that contains the link.
  • If the Status is Error, the link is broken.

Steps to List All Broken Links in a List:

If you want to create a list of broken links of the workbook, do as follows.

  • First, you need to open the workbook that contains link cells.
  • On the Kutools Tab, select the Link option, then choose the *Find and Break Broken Links * option.

Kutools Tab
Kutools Tab

  • It will display the Find and Break Broken Links Dialog Box.
  • Filter – You need to choose the All broken links option from this drop-down list.
  • Now, you will see all the broken links of the workbook in the Find and Break Broken Links Dialog box.
  • Refer to the below image.

List and Filter Link Based on Data Source:

You can list all links based on a specific data source. To do this, follow the below steps.

  • You need to open the workbook that contains link cells.
  • Go to the Kutools Tab, select the Link option, then choose the *Find and Break Broken Links * option.

Kutools Tab
Kutools Tab

  • It will display the Find and Break Broken Links Dialog Box.
  • Filter – ** You need to **change the filter to the data source.
  • Then, you will have a list of cells with links based on the specific data source.

Break Any Links:

  • You can break any links from the data source.
  • To do that, on the Kutools Tab, select the Link option, then choose the *Find and Break Broken Links * option.

Kutools Tab
Kutools Tab

  • It will display the Find and Break Broken Links Dialog Box.
  • You need to check the links that you want to break.
  • Then, click the Break link button.
  • Now, you will see that all the links are broken and the cell contents are replaced in the currently displayed values.

Summary:

In the above article, you can clearly understand the steps to Find and Break Broken Links in Excel Office 365 with Kutools. ** Don’t forget to share your **feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!

Keep Reading:

Discussion

pic
Editor guide