Trace where a formula comes from and goes to (even across sheets)
The Formula Auditing Tool is one of the most important tools you will learn about. It helps you visualise where a formula is looking and can be used when checking whether a formula has been correctly built in Excel.
We use the Formula Auditing Tools to:
- Check which cells are being referred to in a calculation
- Identify differences in formula in rows or columns
- Check whether cells are important to the spreadsheet when we want to delete them (or rows or columns)
You can find the Formula Auditing tools in the formula tab
- Trace Precedent
- Trace Dependent, and
- Remove arrows
To see the full course contents click here.