How to Find and Break Broken Links in Excel Office 365?
Tags: findandbreakbrokenli, kutoolsexceltutorial, kutools
Published: 2020-11-27 09:10:57

---
title: How to Find and Break Broken Links in Excel Office 365?
published: true
date: 2020-11-26 09:23:08 UTC
tags: FindandBreakBrokenLi,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-find-and-break-broken-links-in-excel-office-365/
---

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](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) 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**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-11.png)<figcaption id="caption-attachment-18205">Kutools Tab</figcaption>

- 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**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that contains link cells.
- On the **Kutools Tab, select** the **Link** option, then choose the **Find and Break Broken Links ** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-11.png)<figcaption id="caption-attachment-18205">Kutools Tab</figcaption>

- 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**](https://geekexcel.com/open-a-workbook-using-shortcut-in-excel-365/) that contains link cells.
- Go to the **Kutools Tab, select** the **Link** option, then choose the **Find and Break Broken Links ** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-11.png)<figcaption id="caption-attachment-18205">Kutools Tab</figcaption>

- 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](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-11.png)<figcaption id="caption-attachment-18205">Kutools Tab</figcaption>

- 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.](https://geekexcel.com/)** Keep Learning!

### Keep Reading:

- [Add the Same Text or Characters in a Range of Cells in Excel 365](https://geekexcel.com/how-to-add-the-same-text-or-characters-in-a-range-of-cells-in-excel-365/)
- [How to Change Case of Text to All Caps, Lower and Proper in Excel 365?](https://geekexcel.com/how-to-change-case-of-text-to-all-caps-lower-and-proper-in-excel-365/)