Trace where a formula comes from and goes to (even across sheets)

Please purchase the course before starting the lesson.

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

where-is-the-formula-auditing-toolThe main buttons we will focus on are:

  • Trace Precedent
  • Trace Dependent, and
  • Remove arrows

To see the full course contents click here.

Back to: Advanced Excel Course > Function and Formula Basics