Microsoft Excel: Go To Special - Precedents And Dependents
In this video, we have covered the precedents and dependents cell selection options of the Go To Special feature in Microsoft Excel. These options are very helpful when we want to find out which cells are used in the calculation using a formula. For this Precedents will be used. We can also find out if a value in a cell is being referred to in some other cell through a formula. For this dependents are used. Here we get two options for both precedents and dependents. They are direct only and all levels. The direct-only will select only the first level of the cells that are directly involved. But the all levels option will select all the cells that are directly or indirectly involved. The video covers them with examples. Additionally, the video also covers how to trace precedents and dependents graphically.
I hope this video proves to be informative. Thank you.