Excel Formula & Formula-Auditing Shortcuts

Ctrl+` (the backtick key, usually above Tab) toggles the entire sheet between showing calculated results and showing the raw formula text in every cell. This is the fastest way to audit a model: switch into formula view, and you can visually scan for inconsistencies — a row where someone hardcoded a number instead of referencing a cell, or a formula that wasn't copied correctly and still points at last year's column. It also widens columns awkwardly since formula text is usually longer than the displayed result, so it's a mode you toggle in and out of rather than leave on. F4 inside formula editing cycles a cell reference through its absolute/relative states, covered in more detail on the data-entry page, but it's worth repeating here because it's the single biggest time-saver when building a formula that references both a fixed cell (like a constant in row 1) and a relative range that needs to shift as you fill it down or across. Trace Precedents (Ctrl+[ on Windows; the Mac equivalent varies by version and is sometimes only available via the Formulas ribbon) draws arrows back to the cells that feed into the current formula. Its counterpart, Trace Dependents, shows which downstream cells rely on the current one — essential before deleting or restructuring a cell in a model you didn't build yourself, since deleting a cell that's quietly referenced thirty rows down causes a #REF! error that can be hard to locate after the fact. Ctrl+Shift+Enter still matters for legacy array formulas and certain older functions even though Excel 365's dynamic arrays mean most new array-style formulas confirm with a normal Enter and spill automatically. If you open an older workbook (or one shared by someone using an older Excel version) and a formula that should return multiple values only shows the first one, re-entering it with Ctrl+Shift+Enter often fixes it — Excel wraps it in curly braces {} to show it's an array formula, which you should never type manually since Excel adds them itself. Shift+F3 opens the Insert Function dialog, which is genuinely useful when you know the shape of the calculation you need (a lookup, a count with conditions, a date calculation) but can't remember the exact function name or argument order — it's a guided builder rather than a blank formula bar. Forcing a recalculation with F9 becomes necessary specifically when a workbook's calculation mode has been set to Manual rather than the default Automatic — a setting sometimes changed deliberately on very large, calculation-heavy workbooks to avoid the performance cost of recalculating everything after every single keystroke, but which then requires this explicit trigger to actually refresh displayed values after making changes. If a workbook is showing values that clearly should have updated after an edit but haven't, checking the calculation mode under Formulas > Calculation Options is worth doing before assuming something else is broken. Evaluate Formula, while not bound to a default keyboard shortcut, is a genuinely underused debugging tool for anyone working with deeply nested formulas — rather than trying to mentally trace through several layers of nested IF statements or lookup functions, this dialog lets you click through the formula's evaluation one step at a time, watching each inner function resolve to its actual value in sequence, which is often far faster at locating exactly where a formula's logic diverges from what you expected than staring at the raw formula text trying to trace it by eye alone.