Coronavirus (COVID-19) information: All courses at all locations are available as live online classes. Limited in-person classes in some locations. Our offices remain open. Learn more.

×

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.