How to Trace All Dependents or Precedents in Excel Office 365?
Tags: kutools, tracealldependentsor
Published: 2020-08-21 16:54:37

---
title: How to Trace All Dependents or Precedents in Excel Office 365?
published: true
date: 2020-08-21 16:24:06 UTC
tags: Kutools,TraceAllDependentsor
canonical_url: https://geekexcel.com/how-to-trace-all-dependents-or-precedents-in-excel-office-365/
---

## Trace All Dependents or Precedents in Excel:

In this tutorial, we will guide you to learn how to **Trace All Dependents or Precedents in Excel Office 365** using **Kutools**. Excel’s Kutools feature has many functions to make your work simple. Thereby, we are going to use **Monitor precedents and**  **dependents** feature to trace them quickly. 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.

 

## Trace All Dependents and Precedents With One Click in Real-Time:

Let’s see how to trace all dependents and precedents in Excel, do as follows.

- You have to enable this feature by clicking the **Kutools** tab, **select** the “ **More”** option under the formula section, then **choose**  **Monitor**  **Precedents and Dependents** option from the menu.

![Select Monitor Precedents and Dependents](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-55.png)<figcaption id="caption-attachment-12173">Select Monitor Precedents and Dependents</figcaption>

- Now, you can select a range where you want to show the precedents and dependents in the current worksheet.
- The selected range has been displayed the result like below screenshot.

![Select a Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-40.png)<figcaption id="caption-attachment-12174">Select a Range</figcaption>

### **Note:**

If you want to disable this trace, again go back to the **Kutools** option, **choose** the “ **More** ” under the formula section, and **select** the **Monitor**  **Precedents and Dependents** option from the menu.

## Trace Only Dependents or Precedents With One Click in Real-Time:

You can trace only the dependents or precedents in Excel with a single click. Follow the below steps.

- Go to the **Kutools** tab, **Select**  **More** option under the **Formula** section, then **choose**  **Monitor Precedents of**  **Ranges** or **Monitor Dependents of Ranges** to trace them in the current spreadsheet.

![Select Monitor Precedents of ranges or Monitor Dependents of Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/3-33.png)<figcaption id="caption-attachment-12176">Select Monitor Precedents of ranges or Monitor Dependents of Ranges</figcaption>

- Then, select a range. It will show the precedents or dependents in real-time.
- If you select Monitor Dependents of Ranges, it will display the output like below.

![Trace Dependents](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-16.png)<figcaption id="caption-attachment-12177">Trace Dependents</figcaption>

- If you select Monitor Precedents of Ranges, it will display the out as below.

![Trace Precedents](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-13.png)<figcaption id="caption-attachment-12178">Trace Precedents</figcaption>

### **Note:**

If you want to disable this trace, again go back to the **Kutools** option, **choose** the **“More”** under the formula section, and **select** the **Monitor**  **Precedents of Ranges or Monitor Dependents**  **of Ranges** option from the menu.

## A Short Synopsis:

I hope, in this tutorial we guided you to learn how to **Trace All Dependents or Precedents in Excel Office 365** using **Kutools**. Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!