Excel has a very useful feature when it comes to formula auditing: It allows you to insert arrows to all preceding or depending cells. The problem: You can only apply it for one cell at once. But what, if you want to audit a larger range of cells? Here is how to bulk insert trace… Continue reading Bulk Trace Dependents & Precedents: How to Add Arrows for Many Cells!
Tag: dependents
Precedents and Dependents: Easily Trace Related Cells in Excel
Let’s assume the following situation: You receive an Excel file from your colleague and have to understand it as quickly as possible. How do you start?