Excel Guides

Viewing Formula Results in Excel

When you enter a formula in Excel, the result of that formula is displayed in the cell where you entered it. You can also view the results of formulas in other cells by selecting those cells. When a cell that contains a formula is selected, the formula appears in the formula bar above the worksheet.

You can also have Excel show you all the formulas in a worksheet by displaying the Formulas View. To do this, click the View tab on the Ribbon and then click the Formulas button in the Show group. All the formulas in the worksheet will be displayed.

If you want to see just the formulas that refer to a particular cell, you can use Trace Precedents and Trace Dependents. To do this, select the cell and then click Trace Precedents or Trace Dependents on the Formulas tab (in the Formula Auditing group).

You can also have Excel evaluate part of a formula for you. To do this, select the part of the formula that you want evaluated and then click Evaluate Formula on the Formulas tab (in the Formula Auditing group).

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.