![](https://image.jimcdn.com/app/cms/image/transf/dimension=475x1024:format=png/path/sed039f50cee9e95f/image/ib145e66b7f4612b0/version/1530768416/image.png)
Every now and then you will find a cell reference that is pointing to a different worksheet. One way to find the name of the worksheet that it is referencing is to look inside the formula bar. A much efficient way is to go to the (1) Formula tab, and select (2) Trace Precedents. An icon (in the shape of a grid) appears with a dash line and an arrow. Double-click the line and inside a dialog box is the name of the worksheet. Click the OK button to take you directly to the referenced worksheet.
Write a comment