75 Essential Excel tips

Excel will draw blue arrows from every cell the formula references to the cell containing the formula. Now you can see where that data is coming from. Auditing also allows you to select a cell containing a value and choose Trace Dependants, which will draw arrows from the cell to all the cells containing formulas that reference that value. ................
................