How to Show Formulas in Excel

How to Display Formulas in Excel

Excel Training

Excel Training Features:

  • Interactive bite-sized lessons

  • Get Certified

  • Accurate skill assessments

  • Customizable, LMS-ready content

Users love us
4.9 stars out of 5 on G2

4.9 out of 5 on G2

How to Show Formulas in Excel

You can better understand what’s going on in your workbooks by showing and highlighting all the formulas in a sheet.

Show/Hide Formulas

By default, Excel displays the results of formulas in the worksheet instead of showing the actual formulas. However, you can choose to have Excel display the formulas so you can see how they’re put together.

  1. Click the Formulas tab.
  2. Click the Show Formulas button.
    Display Formulas Show/Hide Formulas

    Formulas are displayed in the worksheet and the columns widen to accommodate the formulas, if necessary.

    If you display formulas and then select a cell that contains a formula, colored lines appear around cells that are referenced by the formula.

  3. Click the Show Formulas button again to hide the formulas.
    Display Formulas Show/Hide Formulas

Formulas are no longer displayed and the columns return to their original sizes.

Highlight Formulas

If you don’t want to see the actual formulas, but want to know which cells contain them, highlight cells with formulas instead.

  1. Click the Home tab.
  2. Click the Find & Select button.
  3. Select Formulas.
    Display Formulas Show/Hide Formulas

Any cells that contain a formula are highlighted; however, this doesn’t change the cell formatting. When you click any other cell in the worksheet, the highlighted cells are unselected.