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.

Learning how to subtract in Excel is one of the more useful things you can start to use in your spreadsheets. Our guide on Excel subtraction will show you how to get started.

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

Now that you know how to show formulas in Exccel 2013, you will be able to view the formula that is being used to display a value in your cells.

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.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy