You’ve probably had a moment in Excel when your numbers just didn’t add up. A common solution is to comb through every cell one by one or start your calculations all over again. At least, I thought those were the only options I had until I discovered that Excel has a dedicated toolkit for exactly this situation. Head to the Formulas tab in Excel’s desktop app, not the web version. Between the Function Library and Calculation features, you’ll find a group called Formula Auditing. It’s easy to overlook, but inside are seven tools that can help you diagnose broken formulas and figure out exactly where things went wrong. Related Excel finally fixed its biggest data entry problem, and it’s a lifesaver One click in the Data tab can catch almost all issues. Trace Precedents and Trace Dependents Find out where your numbers come from and where they go Screenshot by Ada These two features are the natural starting point. Trace Precedents draws visual arrows from every cell feeding data into your selected formula, so if …