- Aug 27, 2004
- Understanding Formula Basics
- Understanding Operator Precedence
- Controlling Worksheet Calculation
- Copying and Moving Formulas
- Displaying Worksheet Formulas
- Converting a Formula to a Value
- Working with Range Names in Formulas
- Working with Links in Formulas
- Formatting Numbers, Dates, and Times
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.
Choose Tools, Options to display the Options dialog box.
Choose the View tab.
Activate the Formulas check box.
Click OK. Excel displays the worksheet formulas.
You can also press Ctrl+´ (backquote) to toggle a worksheet between values and formulas.