Home > Articles

  • Print
  • + Share This
This chapter is from the book

Displaying Worksheet Formulas

By default, Excel displays the results of a formula in cells instead of the formula. If you need to see a formula, you can simply choose the appropriate cell and look at the formula bar. However, sometimes you'll want to see all the formulas in a worksheet (such as when you're troubleshooting your work). To display your worksheet's formulas, follow these steps:

For more information about solving formula problems, see "Troubleshooting Formulas," p. 107.

  1. Choose Tools, Options to display the Options dialog box.

  2. Choose the View tab.

  3. Activate the Formulas check box.

  4. Click OK. Excel displays the worksheet formulas.


You can also press Ctrl+´ (backquote) to toggle a worksheet between values and formulas.

  • + Share This
  • 🔖 Save To Your Account