Tracking cells referenced by formulas

Describe:

Formulas that refer to many cells for calculations are common, and it's easy to check the formula, audit results, because the source of the formula reference is too complex to cause trouble, and here's an example of how to tag which cells the formula refers to, or which cells are referenced indirectly. The approximate step is to enter the formula in the A1 cell input 100,a9 input 200,c2: =a1+50, enter, continue to enter E5 in the =a9+c2 cell, to know what other cells are involved in the cell formula calculation, you can select this cell, click the formula Audit--trace the reference cell, You can see the blue arrows pointing to C2 and E9, which means that the results of E5 are determined by the two cells of C2 and E9, and that the formula distance to the reference cell is especially far away to help position the formula reference.

Steps:

Step 1: First, we create a new spreadsheet, in the A1 cell input 100,a9 input 200,C2 input formula: =a1+50.
Step 2: Enter, C2 get result 150, then continue entering =A9+C2 in E5 cell.
Step 3: Show the result is 350, if we want to know what other cells are involved in the calculation of the cell formula, we can select the cell, click the menu bar-formula--formula review--to track the reference cell.
Step 4: At this point, the E5 cell appears with a blue arrow pointing to C2 and E9, which indicates that the results of E5 are determined by the two cells C2 and E9.

Gif:

Tracking cells referenced by formulas