If you’re trying to figure out where your complicated Excel model might be going off-track, or perhaps you’ve inherited someone else’s work and you just want to see the formulas used at a glance, use the Formula Auditing mode to help review the sheet.

Pressing Ctrl-` will toggle between displaying formulas and values in the sheet so you can read it more easily. You’ll probably need to expand column widths to show the larger formulas completely, but it’s still a useful tool.