How to Show Formulas in Excel 2013

Learning how to show formulas in Excel 2013 is a helpful way for you to determine why you might not be calculating the desired result in one of your cells. When you are displaying the formulas in the cells instead of the values, Excel will also highlight the cells that are part of that formula’s calculation, allowing you to see what is going into determining your cell value.

Our steps below will show you the process needed to show formulas in cells instead of their values, and it will show you how to do it with just a few short steps. This is something that you can toggle on or off in a few seconds, which is helpful when you are troubleshooting issues within your spreadsheet.


View Formulas Instead of Values in Excel 2013

The steps below are going to adjust the settings in your Excel worksheet so that the formula is visible inside of the cell instead of the value of the formula. You can simply follow these steps again to switch it back to displaying the value instead.

You can also view a formula by selecting the cell containing the formula, then looking at the formula bar above the spreadsheet, as in the image below.

view formula in formula bar



Step 1: Open the spreadsheet containing the formulas that you want to show.


Step 2: Click the Formulas tab at the top of the window.

click the formula tab



Step 3: Click the Show Formulas button in the Formula Auditing section of the ribbon at the top of the window.

how to view formulas in excel 2013



Are you having trouble with a formula in Excel 2013? This simple guide to formulas can help you figure out where you might be going wrong. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.