Excel provides a really simple and quick way to show formulas in cells, and in a moment, you will make sure of this.
By default, Excel shows the results of formulas. To show the formulas instead of their results, press CTRL + ` (you can find this key above the tab key).
1. When you select a cell, Excel shows the formula of the cell in the formula bar.
2. To display all formulas, in all cells, press CTRL + ` (you can find this key above the tab key).
3. Press ↓ twice.
Note: as you can see, Excel highlights all cells that are referenced by a formula.
4. To hide all formulas, press CTRL + ` again.
5. If you can't find the grave accent (`) on your keyboard, on the Formulas tab, in the Formula Auditing group, click Show Formulas.
Note: to hide all formulas, click Show Formulas again. Visit our page about formula auditing in Excel to learn more about tracing precedents, tracing dependents, error checking, etc.