Excel shortcuts

5 Easy Ways to Show Formulas in Excel

If you're working with a lot of data in Excel, you may find yourself needing to see all of the formulas that you've used in a worksheet. There are a few different ways that you can do this, and we'll go over five of the most popular methods below.

1. Use the Show Formulas Button

The easiest way to show formulas in Excel is to use the Show Formulas button on the Home tab. This button looks like an equal sign and is located in the Editing group. When you click it, all of the formulas in your worksheet will be displayed.

2. Use the Show Formulas Option in the View Tab

If you prefer, you can also show formulas in Excel by going to the View tab and selecting the Show Formulas option. This option is located in the Show group.

3. Use the Keyboard Shortcut

If you want to show formulas in Excel quickly, you can use the keyboard shortcut Ctrl + ` (grave accent). This shortcut will toggle the formulas on and off, so you can press it again to hide the formulas once you're done.

4. Use the Name Box

Another way to show formulas in Excel is to use the Name box. This is the small box to the left of the formula bar. Simply click in the Name box and type the letter "R" followed by the row number. For example, if you want to see the formulas in row 5, you would type "R5" in the Name box.

5. Use the Go To Feature

The final way to show formulas in Excel is to use the Go To feature. This can be accessed by pressing Ctrl + G or by going to the Home tab and clicking the Find & Select button. Then, click Go To. In the Go To dialog box, click the Special button. This will open the Go To Special dialog box. In the Go To Special dialog box, select the Formulas option and click OK. This will select all of the cells in your worksheet that contain formulas.

Once you've selected the cells with formulas, you can press F2 to edit the formulas or you can press Ctrl + C to copy them. You can also use the other options in the Find & Select menu to find specific formulas or to replace them with new values.

These are just a few of the ways that you can show formulas in Excel. Experiment with each of these methods to see which one works best for you. And, if you have any other tips or tricks for working with formulas in Excel, be sure to share them in the comments below.

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.