MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2020: See Which Cells Depend on the Current Cell


July 16, 2020 - by Bill Jelen

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.


Bill Jelen is the author / co-author of
Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.