Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Tracing Dependent Cells.
Written by Allen Wyatt (last updated August 26, 2023)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021
You can use the tools on the Formulas tab of the ribbon (in the Formula Auditing group) to determine relationships between cells in your worksheet. For instance, you might want to determine which cells refer to a value in a particular cell. All you need to do is select the cell in question and then click on the Trace Dependents tool. If there are any other cells that refer to the selected cell in a formula, Excel draws arrows between the cells. This allows you to graphically see the relationship between cells.
If you click on the Trace Dependents tool again, Excel displays not just the direct dependents, but the first level of indirect dependents as well. Clicking your mouse on the Remove Arrows tool removes one of the levels of auditing arrows. If you only want to remove some of the arrows, click the down-arrow to the right of the Remove Arrows tool to see your options.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8626) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. You can find a version of this tip for the older menu interface of Excel here: Tracing Dependent Cells.
Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!
There are a variety of ways you can count information in different groupings. One convenient way is to use the ...
Discover MoreCheck boxes, just like those used in Windows dialog boxes, can be a great addition to a worksheet. Here's how to add them ...
Discover MoreWhen you add subtotals to a worksheet, Excel typically places them in the same column that you are subtotaling. If you ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2023-08-26 11:16:09
J. Woolley
For more on this subject, see https://excelribbon.tips.net/T008271_Accessing_Dependent_and_Precedent_Information.html
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2024 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, Excel in Microsoft 365, and 2021. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here:
Comments