Excel formula lookup

[Manoj Poddar]

HI

while CTRL + [ takes you to the first link in formula is there a way to navigate to 2nd link as well. For example if my formula is A2+Sheet2!A1, it will take me to A2 cell but then how do i move to Sheet2!A1?

Any way out?

 

[Hui]

Manoj

Firstly, Welcome to the Chandoo.org Forums

have you tried : http://www.jkp-ads.com/RefTreeAnalyser.asp