This chapter is from the book
Displaying Worksheet Formulas
By default, Excel displays in a cell the results of the cell's formula rather than the formula itself. If you need to see a formula, select the appropriate cell and look at the formula bar. However, sometimes you want to see all the formulas in a worksheet such as when you're troubleshooting your work. To display your worksheet's formulas, select Formulas, Show Formulas.
→ |
For more information about solving formula problems, see Chapter 5, "Troubleshooting Formulas." |