Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
add comment

1 Answer

up vote 3 down vote accepted

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

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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