asked 36.2k views
1 vote
Why would you press Ctrl+` in Excel?

asked
User Hwang
by
8.4k points

1 Answer

6 votes

Final answer:

Pressing Ctrl+` in Excel allows you to view and switch between formulas and formula results in cells.

Step-by-step explanation:

In Excel, pressing Ctrl+` (grave accent) allows you to view and switch between the formulas and the formula results in the cells. This shortcut helps you check and verify the formulas used in a worksheet easily.

For example, if you have a formula in a cell that adds up numbers, pressing Ctrl+` will show the actual formula in the cell, and pressing it again will switch back to the result of the formula.

Using Ctrl+` can be particularly useful when troubleshooting or auditing complex spreadsheets that contain numerous formulas.