Coronavirus (COVID-19) information: All courses at all locations are running as live online classes. Our offices remain open with limited staff. 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.