💻 Software
Following Excel precedents to cells on other sheets
Fresh5 days ago
Mar 15, 202654758 viewsConfidence Score0%
0%
Problem
Let's say I have a cell that references another cell, on a different sheet. For example, cell A2 (of Sheet1) below. When I press the extremely useful Trace Precedents button, it draws arrows from the cells being referenced by the formula in the selected cell. As you can see, for the off-sheet refer…
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Following Excel precedents to cells on other sheets
Low Risk
Try double-click on the dotted line - that should bring up a Goto box.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix