Let's say I have a cell that references another cell, on a different sheet. For example, cell A2 (of Sheet1) below.

enter image description here

When I press the extremely useful Trace Precedents button, it draws arrows from the cells being referenced by the formula in the selected cell.

enter image description here

As you can see, for the off-sheet reference, it shows a little icon off to the side (in cell C3 here—but C3 is completely uninvolved), and draws an arrow from there.

I want to go to the off-sheet cell, in this case Sheet2!A1. I've tried right-clicking on the little icon and other natural actions, to no avail. Surely there is a way?

link|improve this question
feedback

1 Answer

up vote 2 down vote accepted

Try double-click on the dotted line - that should bring up a Goto box.

link|improve this answer
brilliant! I almost destroyed my monitor after hours of trying!! – Jake Oct 4 '11 at 6:10
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.