When you want to find out where a precedent cell is located, you can use the Trace Precedents feature in Excel. This feature allows you to trace cells that are referenced by the cell you are currently viewing. To use this feature, follow these steps:
Excel will now display arrows that show all of the cells that are referenced by the cell you selected in Step 1. These arrows are called precedent arrows. If you want to see where a particular precedent arrow is pointing, simply hover your mouse over the arrow and Excel will display a tooltip that shows the address of the precedent cell. You can also double-click a precedent arrow to select the precedent cell.