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

@mhussaain 

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

Excel will display a sheet icon with an arrow:

S1707.png

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

S1708.png

Select a precedent and click OK.