Sometimes it is useful to see the formulas in all the cells in a worksheet rather than the values. To show formulas:
- Select any cell in the worksheet in which you want to show the formulas.
- On the FORMULAS tab, in the Formula Auditing group, click the Show Formulas command:
- Instead of values, you can now see the formulas in each cell:
- To go back to showing values, simply click the Show Formulas command again.