Excel shortcuts

The Show Formulas Shortcut Key in Excel

If you work with formulas in Excel, you know that it can be tedious to constantly select the cell, click on the formula bar, and then make your changes. But did you know that there's a shortcut key that will allow you to quickly edit formulas without having to use the mouse?

The shortcut key to show formulas in Excel is Ctrl + ` (grave accent). When you press this key combination, all of the formulas in the worksheet will be displayed in the cells instead of the results of the formulas. This can be a great way to check your formulas for errors, or to see how they are calculated.

To exit the formula view and return to the normal view, simply press the Ctrl + ` shortcut key again. You can also press the Esc key on your keyboard.

If you want to learn more about shortcut keys in Excel, be sure to check out our other articles on the subject. And don't forget to sign up for our free email course to learn even more about using Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.