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?

2 Answers

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

To find various instances that a cell value (say sheet "sheet1", cell "T10") is used in all other sheets of the same workbook, use ctrl-F to bring up a "Find, replace" window. In 'Find what' and enter the location info of the cell, i.e. 'sheet1'!T10. Make sure "Within:" is set to "workbook". Click "Find All" and you will see a list that you can sort through to see where and how the cell is used.