Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
up vote 5 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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .