Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
This chapter is from the book

This chapter is from the book

Displaying Worksheet Formulas

By default, Excel displays in a cell the results of the cell’s formula instead of the formula itself. If you need to see a formula, you can simply select 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).

→ For more information about solving formula problems, see Chapter 5, “Troubleshooting Formulas.”

Displaying All Worksheet Formulas

To display all your worksheet’s formulas, select Formulas, Show Formulas.

Displaying a Cell’s Formula Using FORMULATEXT()

In some cases, rather than showing all the sheet’s formulas, you might prefer to show the formulas in only a cell or two. For example, if you’re presenting a worksheet to other people, that sheet might have some formulas you want to show, but it might also have one or more proprietary formulas that you don’t want your audience to see. In this case, you can display individual cell formulas by using the new FORMULATEXT() function:

FORMULATEXT(cell)

cell

The address of the cell that contains the formula you want to show

For example, the following formula displays the formula text from the cell in D9:

=FORMULATEXT(D9)

  • + Share This
  • 🔖 Save To Your Account