Excel shortcuts

25 Excel Shortcuts for Showing Formulas (and Hiding Them, Too)

If you work with Excel spreadsheets on a regular basis, you know how important it is to be able to see the formulas that are used to calculate the values in cells. After all, if you can't see the formulas, how can you check them for accuracy?

Fortunately, there are a few different ways to display formulas in Excel. You can use the shortcut keys listed below to quickly show or hide formulas.

1. Use the Keyboard Shortcut CTRL + `

The easiest way to show formulas in Excel is to use the keyboard shortcut CTRL + ` (grave accent). This shortcut will toggle the display of formulas on and off.

2. Use the Show Formulas Button on the Formulas Tab

If you prefer to use the mouse, you can click the Show Formulas button on the Formulas tab. This button looks like a backward P ().

3. Use the Show Formulas Option in the Right-Click Menu

Another way to show formulas is to right-click on a cell and select Show Formulas from the menu that appears.

4. Use the Show Formulas Option in the Format Cells Dialog Box

You can also use the Format Cells dialog box to show formulas. To do this, select the cells that you want to affect, then click the Format button on the Home tab. In the Format Cells dialog box, select the Protection tab and then check the Show Formulas in Cells checkbox.

5. Use the Show Formulas Option in the Excel Options Dialog Box

If you want all formulas in a workbook to be visible, you can use the Excel Options dialog box. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Formulas category and then check the Show Formulas in Cells checkbox.

6. Use the Show Formulas Option in the Advanced Options Dialog Box

You can also use the Advanced options dialog box to show formulas. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Advanced category and then scroll down to the Display section. In the Display section, check the Show Formulas in Cells checkbox.

7. Use the Show Formulas Option in the Preferences Dialog Box

If you use the Mac version of Excel, you can use the Preferences dialog box to show formulas. To do this, click the Excel menu, then click Preferences. In the Preferences dialog box, select the View tab and then check the Formulas checkbox.

8. Use the Show Formulas Option in the Options Dialog Box

Another way to show formulas in the Mac version of Excel is to use the Options dialog box. To do this, click the Excel menu, then click Preferences. In the Preferences dialog box, select the Options tab and then check the Formulas checkbox.

9. Use the Show Formulas Option in the View Options Dialog Box

You can also use the View Options dialog box to show formulas in the Mac version of Excel. To do this, click the View menu, then click View Options. In the View Options dialog box, select the Formulas checkbox.

10. Use the Show Formulas Option in the Format Cells Dialog Box

In the Windows version of Excel, you can use the Format Cells dialog box to show formulas. To do this, select the cells that you want to affect, then click the Format button on the Home tab. In the Format Cells dialog box, select the Protection tab and then check the Show Formulas in Cells checkbox.

11. Use the Show Formulas Option in the Excel Options Dialog Box

Another way to show formulas in the Windows version of Excel is to use the Excel Options dialog box. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Formulas category and then check the Show Formulas in Cells checkbox.

12. Use the Show Formulas Option in the Advanced Options Dialog Box

You can also use the Advanced options dialog box to show formulas in the Windows version of Excel. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Advanced category and then scroll down to the Display section. In the Display section, check the Show Formulas in Cells checkbox.

13. Use the Show Formulas Option in the Preferences Dialog Box

If you use the Mac version of Excel, you can use the Preferences dialog box to show formulas. To do this, click the Excel menu, then click Preferences. In the Preferences dialog box, select the View tab and then check the Formulas checkbox.

14. Use the Show Formulas Option in the Options Dialog Box

Another way to show formulas in the Mac version of Excel is to use the Options dialog box. To do this, click the Excel menu, then click Preferences. In the Preferences dialog box, select the Options tab and then check the Formulas checkbox.

15. Use the Show Formulas Option in the View Options Dialog Box

You can also use the View Options dialog box to show formulas in the Mac version of Excel. To do this, click the View menu, then click View Options. In the View Options dialog box, select the Formulas checkbox.

16. Use the Show Formulas Option in the Format Cells Dialog Box

In the Windows version of Excel, you can use the Format Cells dialog box to show formulas. To do this, select the cells that you want to affect, then click the Format button on the Home tab. In the Format Cells dialog box, select the Protection tab and then check the Show Formulas in Cells checkbox.

17. Use the Show Formulas Option in the Excel Options Dialog Box

Another way to show formulas in the Windows version of Excel is to use the Excel Options dialog box. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Formulas category and then check the Show Formulas in Cells checkbox.

18. Use the Show Formulas Option in the Advanced Options Dialog Box

You can also use the Advanced options dialog box to show formulas in the Windows version of Excel. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Advanced category and then scroll down to the Display section. In the Display section, check the Show Formulas in Cells checkbox.

19. Use the Show Formulas Option in the Preferences Dialog Box

If you use the Mac version of Excel, you can use the Preferences dialog box to show formulas. To do this, click the Excel menu, then click Preferences. In the Preferences dialog box, select the View tab and then check the Formulas checkbox.

20. Use the Show Formulas Option in the Options Dialog Box

Another way to show formulas in the Mac version of Excel is to use the Options dialog box. To do this, click the Excel menu, then click Preferences. In the Preferences dialog box, select the Options tab and then check the Formulas checkbox.

21. Use the Show Formulas Option in the View Options Dialog Box

You can also use the View Options dialog box to show formulas in the Mac version of Excel. To do this, click the View menu, then click View Options. In the View Options dialog box, select the Formulas checkbox.

22. Use the Show Formulas Option in the Format Cells Dialog Box

In the Windows version of Excel, you can use the Format Cells dialog box to show formulas. To do this, select the cells that you want to affect, then click the Format button on the Home tab. In the Format Cells dialog box, select the Protection tab and then check the Show Formulas in Cells checkbox.

23. Use the Show Formulas Option in the Excel Options Dialog Box

Another way to show formulas in the Windows version of Excel is to use the Excel Options dialog box. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Formulas category and then check the Show Formulas in Cells checkbox.

24. Use the Show Formulas Option in the Advanced Options Dialog Box

You can also use the Advanced options dialog box to show formulas in the Windows version of Excel. To do this, click the File tab, then click Options. In the Excel Options dialog box, select the Advanced category and then scroll down to the Display section. In the Display section, check the Show Formulas in Cells checkbox.

25. Use the Show Formulas Option in the

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.