MrExcel.com - Your One Stop for Excel Tips & Solutions

Excel 2020: See Which Cells Depend on the Current Cell

July 16, 2020 - by

Excel See Which Cells Depend on the Current Cell. Photo Credit: Edgar Castrejon at Unsplash.com

I previously explained how to Trace Precedents to See What Cells Flow into a Formula. Sometimes you have the opposite problem: You want to see which cells rely on the value in the current cell. 

Choose any cell and click Trace Dependents to see which cells directly refer to the active cell.

The 28 in D6 is referenced by six other formulas in G4:G9. Select D6 and Trace Dependents. Blue arrows point to each of the dependent cells in G4:G9.

Title Photo: Edgar Castrejon at Unsplash.com

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.