Tracking cell formulas in Excel2013

Using formulas in Excel is a regular thing, and formulas often refer to many cells for calculation, even references to tables, and it's easy to get into trouble when checking formulas and auditing results because the source of the formula references is too complex. The case illustrates how to use simple actions to mark which cells a formula refers to, or which cells are referenced indirectly.

① First, we create a new spreadsheet, enter the 100,A9 input 200,C2 input formula in A1 cell: =a1+50.

② carriage return, C2 gets the result 150, and then continues to enter =A9+C2 in the E5 cell.

③ The result is 350, and if we want to know what other cells are involved in the cell formula calculation, we can select the cell and click on the menu bar--formula--formula approval--to trace the reference cell.

④ at this point the E5 cell appears with a blue arrow pointing to C2 and E9, which indicates that the E5 calculation is determined by the two cells of C2 and E9.

⑤ Click the Trace Reference cell button again, the Blue arrows are more advanced, because the C2 cell is also determined by the A1, and the double click arrow can switch between the result and the source, which is very obvious, especially when the formula is far from referring to the cell or across a table, to help us position the formula reference.