Page 19 of 24PREVNEXT

Get to know Excel: Enter formulas

Formulas displayed on the worksheet

Formulas displayed on the worksheet.

You can print formulas to put up on your bulletin board to remind you how to create them.

To print formulas, you'll need to display formulas on the worksheet. In the practice session you'll see how to do this by clicking Formula Auditing on the Tools menu and then clicking Formula Auditing Mode.

Tips

  • You can also press CTRL+` (next to the 1 key) to display and hide formulas.
  • Displaying formulas can help you spot errors.
Page 19 of 24PREVNEXT