Page 313 - Excel 2013 All-in-One For Dummies

Printing the Formulas in a Report 295
Before you can print a worksheet’s formulas, you have to display the for- mulas, rather than their results, in the cells by clicking the Show Formulas button (the one that kind of looks like a page of a calendar with a tiny 15 above an fx) in the Formula Auditing group on the Formulas tab of the Ribbon (Alt+MH).
Excel then displays the contents of each cell in the worksheet as they nor- mally appear only in the Formula bar or when you’re editing them in the
cell. Notice that value entries lose their number formatting, formulas appear in their cells (Excel widens the columns with best-fit so that the formulas appear in their entirety), and long text entries no longer spill over into neigh- boring blank cells.
Excel allows you to toggle between the normal cell display and the formula cell display by pressing Ctrl+`. (That is, press Ctrl and the key with the tilde on top.) This key — usually found in the upper-left corner of your keyboard — does double-duty as a tilde and as a weird backward accent mark: ` (Don’t confuse that backward accent mark with the apostrophe that appears on the same key as the quotation mark!)
After Excel displays the formulas in the worksheet, you are ready to print it as you would any other report. You can include the worksheet column let- ters and row numbers as headings in the printout so that if you do spot an error, you can pinpoint the cell reference right away.
To include the row and column headings in the printout, put a check mark in the Print check box in the Headings column on the Sheet Options group of the Page Layout tab of the Ribbon before you send the report to the printer.
After you print the worksheet with the formulas, return the worksheet to normal by clicking the Show Formulas button on the Formulas tab of the Ribbon or by pressing Ctrl+’.
Book II Chapter 5
Printing Worksheets