1
F2Open the formula in edit mode
Start by putting the cell in a state where you can see its contents directly.
F9debuggingformula inspection
How to Evaluate Part of a Formula with F9 for Faster Debugging
Staring at a complex formula in its entirety will not reveal the cause of an error. Evaluating just a portion with F9 makes it much easier to isolate where things go wrong.
Shortcuts you will master in this article
F9 / F2 / Ctrl + Z
Long formulas are hard to understand without breaking them apart
Nested IF statements, formulas with lookup functions, and array-returning expressions are difficult to diagnose just by looking at the result. F9 is the means to peek at intermediate results.
It is especially powerful when you want to isolate 'which part is still correct.'
Flow for debugging a formula with F9
Understand it as a partial-evaluation operation performed inside edit mode.
2
Shift + ← →Select only the function or range you want to check
Use Shift+arrow to select the suspicious part — such as an IF condition or a MATCH result.
3
F9Evaluate only the selected portion
View the intermediate result and verify whether it matches expectations.
4
Esc / Ctrl + ZExit without accidentally committing
Be careful not to confirm the evaluated result as the cell's permanent value.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Where F9 debugging is most valuable
Effective for dissecting nested IFs, XLOOKUP, and INDEX/MATCH expressions.
Also useful for confirming whether an array or range reference is returning what you expect.
Learn how to exit without confirming at the same time you learn F9 — treat them as a pair.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
F2 | Edit Cell |
Ctrl + Z | Undo |
F9 | Recalculate Workbook |
Frequently Asked Questions
Q. Why does my formula change when I press F9?
A. If you confirm the evaluated result while in edit mode, it replaces the formula. Always use Esc or Undo after inspecting.
Q. What kinds of formulas benefit most?
A. Long nested expressions and formulas where you need to inspect an intermediate lookup result.
Q. How does F9 differ from Ctrl+`?
A. Ctrl+` shows formulas across the entire sheet; F9 lets you inspect one specific part of one formula in fine detail.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →