How to Print Formulas in an Excel 2007 Worksheet A basic
printing technique you may need in Excel 2007 is how to print
the worksheet formulas instead of printing the calculated
results of the formulas. You can check over a printout of the
formulas in your worksheet to make sure that you haven’t done
anything stupid (like replace a formula with a number or use the
wrong cell references in a formula) before you distribute the
worksheet companywide. Follow these steps to print formulas in
an Excel 2007 worksheet: Excel displays the contents of each
cell in the worksheet as they normally appear only in the
Formula bar or when you’re editing them in the cell. Notice that
value entries lose their number formatting, and long text
entries no longer spill over into neighboring blank cells. Excel
widens the columns with best-fit so that the formulas appear in
their entirety. With the formulas displayed, print the worksheet
as you normally would any other report. Return the worksheet to
normal by clicking the Show Formu