如果您在Excel中经常使用公式,您就会知道单个单元格的值可以在许多不同单元格的公式中使用。事实上,不同工作表上的单元格也可能引用该值。这意味着这些单元格依赖于另一个单元格。
在 Excel 中跟踪依赖项
如果您更改该单个单元格的值,它将更改碰巧在公式中引用该单元格的任何其他单元格的值。让我们举个例子来看看我的意思。在这里,我们有一个非常简单的表格,其中我们有三个数字,然后取这些数字的总和和平均值。
因此,假设您想知道值为 10 的单元格 C3 的依赖单元格。如果我们将 10 的值更改为其他值,哪些单元格的值会发生变化?(Which)显然,它会改变总和和平均值。
在Excel 中(Excel),您可以通过跟踪家属直观地看到这一点。您可以通过转到“公式(Formulas)”选项卡,然后单击要跟踪的单元格,然后单击“跟踪依赖项(Trace Dependents)”按钮来执行此操作。
执行此操作时,您将立即看到从该单元格绘制到相关单元格的蓝色箭头,如下所示:
您只需单击单元格并单击“删除箭头(Remove Arrows)”按钮即可删除箭头。但是,假设您在Sheet2上有另一个公式使用 C1 中的值。你能在另一张纸上追踪家属吗?你当然可以!这是它的样子:
如您所见,有一条黑色虚线指向看起来像工作表的图标。这意味着在另一个工作表上有一个依赖单元格。如果双击黑色虚线,它将弹出一个转到对话框,您可以在其中跳转到该工作表中的特定单元格。
所以这对于家属来说几乎是这样。在谈论受抚养人时,很难不谈论先例,因为它们非常相似。正如我们想查看上面示例中哪些单元格受 C3 值的影响一样,我们可能还想查看哪些单元格影响 G3 或 H3 的值。
如您所见,单元格 C3、D3 和 E3 会影响总和单元格的值。这三个单元格在蓝色框中突出显示,箭头指向总和单元格。这很简单,但如果你有一些非常复杂的公式也使用了复杂的函数,那么可能会有很多箭头。如果您有任何问题,请随时发表评论,我会尽力提供帮助。享受!
How to Trace Dependents in Excel
If you work with formulas a lot in Excel, уou know that the value of a ѕingle cell can be used in a formula in many different cells. In fact, cells on a different ѕheеt may referencе that value also. This means that those cells are dependent on the other cell.
Trace Dependents in Excel
If you change the value of that single cell, it will change the value of any other cell that happens to reference that cell in a formula. Let’s take an example to see what I mean. Here we have a very simple sheet where we have three numbers and then take the sum and the average of those numbers.
So let’s say you wanted to know the dependent cells of cell C3, which has a value of 10. Which cells will have their values changed if we change the value of 10 to something else? Obviously, it will change the sum and the average.
In Excel, you can visually see this by tracing dependents. You can do this by going to the Formulas tab, then clicking on the cell you want to trace and then clicking on the Trace Dependents button.
When you do this, you will instantly see blue arrows drawn from that cell to the dependent cells like shown below:
You can remove the arrows by simply clicking on the cell and clicking the Remove Arrows button. But let’s say you have another formula on Sheet2 that is using the value from C1. Can you trace dependents on another sheet? Sure you can! Here’s what it would look like:
As you can see, there is a dotted black line that points to what looks like an icon for a sheet. This means that there is a dependent cell on another sheet. If you double-click on the dotted black line, it’ll bring up a Go To dialog where you can jump to that specific cell in that sheet.
So that’s pretty much it for dependents. It’s kind of hard not to talk about precedents when talking about dependents because they are so similar. Just as we wanted to see which cells are affected by the value of C3 in the example above, we may also want to see which cells affect the value of G3 or H3.
As you can see, cells C3, D3, and E3 affect the value of the sum cell. Those three cells are highlighted in a blue box with an arrow pointing to the sum cell. It’s pretty straight-forward, but if you have some really complicated formulas that use complicated functions too, then there may be a lot of arrows going all over the place. If you have any questions, feel free to post a comment and I’ll try to help. Enjoy!