Excel Tutorial: How to Display Worksheet Formulas in Excel

 How to display worksheet formulas in Excel

Excel displays the result of the formula in a cell rather than the formula itself. With the Show Formulas auditing tool, you can switch the worksheet display so that Excel displays the formulas as entered. To display the formulas in Excel, follow these steps:

  1. 1 From the Formulas tab, choose Show Formulas. Excel displays all formulas in the cells as entered.
  2. Switch the worksheet view to Show Formulas when you want to view the formulas and not the results.
  3. Choose Show Formulas again display the formula results.
  4. Choose File > Save As, navigate to the Excel04lessons folder.
  5. Type excel04_formulas_final as the file name, and click Save.

Take a class from the authors of this tutorial

See available Excel classes and learn from the expert instructors at American Graphics Institute. In-person classes at our locations, online courses, or private training is available.

See Courses

Tutorials Category: Excel Tutorials

These tutorials are created by and the team of expert instructors at American Graphics Institute.