A feature that draws arrows to show which cells provide data to a selected formula.
ลองใช้กับ AITrace Precedents is a formula auditing tool that visually maps the relationship between a formula and the cells it references. By clicking this button, Excel draws blue arrows pointing from the source cells to the active cell, helping users identify data dependencies and troubleshoot calculation errors.
If cell C1 contains '=A1+B1', using Trace Precedents on C1 will display arrows originating from A1 and B1 pointing toward C1.
Go to the Formulas tab and click the 'Remove Arrows' button in the Formula Auditing group.