Forum Discussion
How to reach multiple Linked Cells in an Excel formulas
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?
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.