Microsoft Excel -Auditing an Excel Worksheet

Excel provides powerful Formula Auditing tools to help you understand, debug, and validate formulas.

You’ll find these under:

Formulas Tab → Formula Auditing Group

1️⃣ Tracing Precedents in Excel Formulas

🔎 What Are Precedents?

Precedents are the cells that provide data to a formula.

Example:

If cell C1 = A1 + B1,

Then A1 and B1 are precedents of C1.

✅ How to Trace Precedents:

Select the cell containing the formula.

Go to Formulas tab.

Click Trace Precedents.

🔹 Blue arrows will appear pointing from input cells to the formula cell.

➕ Extra Tips:

Click again to trace multiple levels.

Use Remove Arrows to clear them.

If the arrow is dotted, it may refer to another worksheet.

2️⃣ Tracing Dependents in Excel Formulas

🔎 What Are Dependents?

Dependents are cells that use the selected cell in their formulas.

Example:

If C1 = A1 + B1,

Then C1 is dependent on A1.

✅ How to Trace Dependents:

Select the input cell.

Go to Formulas tab.

Click Trace Dependents.

🔹 Arrows will point from the selected cell to formulas that depend on it.

This is very useful when:

Updating key values

Checking impact before deleting data

Understanding calculation flow

3️⃣ Working with the Watch Window

👀 What is Watch Window?

The Watch Window allows you to monitor important cells without scrolling across sheets.

✅ How to Use:

Go to Formulas tab.

Click Watch Window.

Click Add Watch.

Select the cell(s) to monitor.

Click Add.

You’ll see:

Workbook

Sheet

Cell

Current Value

Formula

💡 Best Use Cases:

• Monitoring totals
• Watching KPIs
• Debugging large financial models
• Tracking values across multiple sheets

4️⃣ Showing Formulas Instead of Results

Sometimes you need to view formulas instead of calculated values.

✅ Method 1:

Press Ctrl + ` (grave accent key)

✅ Method 2:

Go to Formulas tab

Click Show Formulas

This will:

Display formulas in all cells

Expand column widths automatically

Press again to return to normal view.

🎯 Why Formula Auditing Is Important

• ✔ Helps detect errors
• ✔ Improves spreadsheet transparency
• ✔ Makes financial models easier to validate
• ✔ Prevents accidental data corruption
• ✔ Supports audit and compliance checks