To remove these arrows, Go to Formulas > Remove Arrows. This will create arrows on your sheet that will indicate which cells affect the value of the currently selected cell.
STEP 2:Go to Formulas > Trace Precedents. You can use the Trace Precedents to take you to the cell from which you are getting the value. In the example below, cell F6 contains a formula that is getting value from another cell. Precedent cells are the cells that are referred to by a formula. Let’s look at these two features in detail! You can even use a simpler technique to Excel jump to cell in formula using Trace Dependents and Trace Precedents in Excel. This is how you can use the go to cell in Excel! STEP 6:Press Enter and your formula is updated STEP 5: You can select the new range with your mouse and also make any changes to the formula bar STEP 4:This will take you to the referenced cell/range
STEP 3: Press F5 which will bring up the Go To dialogue box and press OK STEP 2: Select the formula argument that you want to edit with your mouse
STEP 1: Double click inside your Excel formula
