Display and print Excel formulas

Applies to
Microsoft Excel 2000

To display the formulas in cells instead of the values they calculate:

  1. Click Options on the Tools menu.
  2. Click the View tab.
  3. Select the Formulas check box under Window options.

This option temporarily increases the width of all columns that you haven't previously adjusted, so you can see the entire formula. You can turn view formulas on and off separately for each worksheet.

To print the formulas, turn on view formulas. If any columns are too narrow to show the entire formula, increase the widths of those columns, and then print the worksheet.

For information about changing column widths, type column width in the Office Assistant or on the Answer Wizard tab in the Excel 2000 Help window, and then click Search.