Showing Formulas

Contact Us or call 1-877-932-8228
Showing Formulas

Showing Formulas

Sometimes it is useful to see the formulas in all the cells in a worksheet rather than the values. To show formulas:

  1. Select any cell in the worksheet in which you want to show the formulas.
  2. On the FORMULAS tab, in the Formula Auditing group, click the Show Formulas command:Show Formulas
  3. Instead of values, you can now see the formulas in each cell:Formulas in Cells
  4. To go back to showing values, simply click the Show Formulas command again.
Next