Hello, how can I follow a dependent (or precedent) of a cell, in a different sheet ?
I mean, if you trace dependents of a cell you see a blue Arrow meaning the dependent cell is in another sheet, but how do you know which sheet and which cell ?
is it possible (somehow) to jump to the sheet and see the dependent(s) cells ?
There is currently no way to trace dependents in another sheet. Someone answered a similar - now closed - question by pointing out that you can trace precedents in another sheet using the excel shortcut ^[ ( that is, Ctrl+[ (Left Bracket)). but (at least for me) ^] will not trace dependents in another sheet. BTW, I would love to be proved wrong on this because it is a serious shortcoming.