• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. Building Basic Formulas > Displaying Worksheet Formulas

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, seeTroubleshooting 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.

TIP

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


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint