We can spend a lot of time looking for information surrounding formula. Formula Auditing tools help us streamline this process. See topic: HP10066253
Trace Precedents
Shows what cells are supplying data to the cell selected.
Trace Dependents
Shows what cells the formula is depending on.
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.
