Excel 2010: Auditing Tools
There are times when you inherit a spreadsheet and wonder how it works. You can identify the cells with formulae, but still have difficulty tracing the sources or subsequent calculations. This is where Excel’s Auditing Tools can help point you in the right direction (literally). Tracing Precedents and Dependents Select a cell with a formula. […]