Aug 26 2022 11:58 PM
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?
Aug 27 2022 02:37 AM
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.