Viewing Formulas

[ LiB ]

As you've already seen, when you create formulas, the result of the formulas is what Excel displays in the worksheet. Although the Edit bar displays the actual formula, you can only view one formula at a time. Excel provides a method to view the formulas in the cells . Having the formulas display is a wonderful tool for proofing and troubleshooting formula errors in your worksheet.

NOTE

If you print the worksheet while the formulas are displayed, the formulas will print, not the formula results.

[ LiB ]