Page 20 of 23PREVNEXT

So that's how! Printing options in Excel

A formula result, and a formula

To print formulas, first display them.

Have you ever wished you could print the formulas you don't use often, and put that printout on your bulletin board so you don't have to create them again next time around? Or perhaps you've been asked to bring your formulas to a meeting.

It's easy to print formulas instead of formula results. On the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode. That's all you have to do to see the formulas in the worksheet. Then print as you normally would.

If you want to print both your formulas and the formula results, you'll need to print two copies, once each way.

Page 20 of 23PREVNEXT