1
Ctrl + `Toggle between value and formula display
See at a glance what is being calculated across the entire sheet.
formula displayreviewCtrl+`
Display All Formulas with Ctrl+` for Dramatically Faster Reviews
Looking only at values means you never see what Excel is actually doing. Ctrl+` is a shortcut that accelerates review speed.
Shortcuts you will master in this article
Ctrl + ` / F2 / Ctrl + End
Looking at values alone means logic errors get missed
Results that look correct may only be correct by coincidence. Switching to formula display reveals reference directions and mixed references all at once.
When inheriting a file from someone else, Ctrl+` is a powerful entry point for understanding what it does.
How to use the formula display shortcut
Think of it as getting a bird's-eye view of the entire sheet you want to review.
2
Ctrl + EndScan through to the far end
Check for irregularities not just in the middle but also near the end of the data.
3
F2Drill into suspicious cells individually
Investigate anomalies you spotted in the overview.
4
Ctrl + `Return to normal view after review
Switching display modes based on the current work phase keeps things efficient.
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.
Situations where Ctrl+` is most effective
Extremely useful when inheriting a summary table built by someone else.
Makes it easy to spot where a copied formula suddenly references a different range.
In final reviews before submission, it catches problems that values alone would hide.
Related Shortcuts
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + ` | Toggle Formula View |
F2 | Edit Cell |
Ctrl + End | Go to Last Used Cell |
Frequently Asked Questions
Q. The column widths get disrupted because formulas are long.
A. Treat it as a temporary review mode — that is fine. For deep investigation of specific cells, use F2 instead.
Q. How often should I use Ctrl+`?
A. It is worth using every time you check formulas or review an inherited file.
Q. Should I look at values or formulas first?
A. If you see an anomalous value, start with values; if you want to trace the logic, start with formula view.
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スキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →