What is the shortcut for Toggle Formula View?
Windows: Ctrl+`. Mac: Ctrl+`.
📊Excel Shortcut
Toggle Formula View
Detailed guide to use "Toggle Formula View" in Excel
Shortcut Keys
The highlighted keys show where to press. Press the required keys together.
Windows
Ctrl
`
Windows shortcut: Ctrl+`
Mac
Ctrl
`
Mac shortcut: Ctrl+`
In Action
This shows a representative pseudo-Excel example of what happens after the shortcut runs. The actual Excel UI may differ slightly.
Auto-playing example
Active: D2Selection: D2:D4Sheet: Sheet1Step 1/2
You can scroll the sheet horizontally
↶↷BIUGeneral
Name Box
D2
Formula Bar
fx=B2-C2◢ | A | B | C | D |
|---|---|---|---|---|
| 1 | Month | Sales | Cost | Margin |
| 2 | Jan | 2000 | 1400 | 600 |
| 3 | Feb | 1850 | 1300 | |
| 4 | Mar | 2100 | 1500 | 600 |
Sheet1
Ready100%
Basic Info
- Category
- Editing
- Difficulty
- ★★☆(Intermediate)
How to Use
- 1Select the target cell/range if needed
- 2Press the highlighted keys shown above together
- 3Toggle Formula View is executed
Practice
Practice this shortcut and build reliable muscle memory.
Usage Tip
Toggle between values and displayed formulas.
Related Shortcuts
More In This Category
FAQ
How do I use Toggle Formula View?
Use it after selecting the target cell or range to speed up edits and fixes.
What shortcuts should I practice after Toggle Formula View?
Practice copy, line break in cell, and reference toggle next and you can move through common Excel work much faster.
Where can I practice Toggle Formula View?
Use the page button to start a focused drill right away. If you switch to full practice, you can review copy, line break in cell, and reference toggle in the same flow.
What is the action preview for Toggle Formula View?
A visual pseudo-Excel simulation showing the before and after state when you run the shortcut.