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
Shows what cells are supplying data to the cell selected.
Shows what cells the formula is depending on.
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.
Further reading: How to Hide Macros in Excel While They Run