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