It's very useful to be able to press CTRL+[ in order to navigate to the first precedent/reference in a formula. (And then to press F5 to jump back to the formula.) However, what if a formula has multiple precendents/references, including some or all that appear on a different worksheet? It would be super useful to be able to continue to navigate through a formula's precedents, jumping from one to the next, in the order that the appear in the formula. Is there a way to do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Is there a way to navigate through a formula's precedents, jumping from one to the next?
- Thread starter alexcr
- Start date
Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
For this, I always use the Formula Ribbon> Evaluate formula.
Reason being, I don't care to look at the precedents, I actually only care about what each piece of the formula returns. You could always use the Trace Precedents as well on the same tab.
Reason being, I don't care to look at the precedents, I actually only care about what each piece of the formula returns. You could always use the Trace Precedents as well on the same tab.
Upvote
0
Similar threads
- Solved
