Following Excel precedents to cells on other sheets
Let's say I have a cell that references another cell, on a different sheet. For example, cell A2 (of Sheet1) below.
When I press the extremely useful Trace Precedents button, it draws arrows from the cells being referenced by the formula in the selected cell.
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?
Try double-click on the dotted line - that should bring up a Goto box.