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 […]

continue reading.....