💻 Software
Is there a way to tell which cells reference a selected cell in Excel?
Fresh7 days ago
Mar 15, 202610509 viewsConfidence Score0%
0%
Problem
In Excel, you can tell a cell to reference another cell in order to calculate its value. I'd like to be to do the opposite, to get any cells that reference the currently-selected cell. Is this at all possible in Excel, either as one of the built-in functions or a VBA script?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Is there a way to tell which cells reference a selected cell in Excel?
Low Risk
Can't say how to use it programmatically, but from the Formulas ribbon, there is a "Formula Auditing" pane that allows you to "Trace Dependents" and will draw a visual arrow on the sheet from the currently selected cell to any that reference it via …
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix