Toggle Formulas in Excel (Ctrl + `)
The Toggle Formulas shortcut allows you to switch between viewing the formula in a cell and the result of the formula. This is useful for auditing and debugging formulas.
Keyboard Shortcut
| Windows | Mac |
|---|---|
| Ctrl + ` | Cmd + ` |
How to Use Toggle Formulas
- Select the worksheet where you want to view formulas
- Press Ctrl + ` (Windows) or Cmd + ` (Mac)
- All formulas in the worksheet will be displayed instead of results
- Press the shortcut again to switch back to displaying results
Tips & Best Practices
- Use this shortcut to quickly audit your formulas for errors
- Combine with Select Current Region to check formulas in a specific table
- Helpful when preparing documentation or training materials showing formulas
FAQ
- Q: Does this change the actual formula?
- No, it only toggles the display between formulas and results; the formulas themselves remain unchanged.
- Q: Can I toggle formulas for a single cell?
- No, this shortcut affects the entire worksheet, not individual cells.