Formula Auditing in Excel

Formula Auditing in Excel


We can spend a lot of time looking for information surrounding formula. Formula Auditing tools help us streamline this process. See topic: HP10066253

formula auditing

Trace Precedents

Shows what cells are supplying data to the cell selected.

excel exampleformula auditing

Trace Dependents

Shows what cells the formula is depending on.

excel example

Watch Window

I love the watch window. It allows you to see what’s happening with cells on other sheets without requiring you to set screen sizes or constantly flipping back and forth.

excel example


Further reading: How to Hide Macros in Excel While They Run

Leave a Reply

You must be logged in to post a comment.