How to reach multiple Linked Cells in an Excel formulas

Copper Contributor

There is formulas like "=Sheet1!D6+Sheet5!C5+Sheet9!A15"

I am able to reach to first cell of the formula e.g. Sheet1!D6 by clicking "ctrl+[", 

How to go to second and third cells of the formulas?

1 Reply


On the Formulas tab of the ribbon, click Trace Precedents.

Excel will display a sheet icon with an arrow:


Double-click on the arrow to display the Go To dialog with a list of precedents.


Select a precedent and click OK.