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

294 Printing the Formulas in a Report
Figure 5-14:
Page 1 of the report in the Print Preview window after adjusting the page breaks in Page Break Preview mode.
3. After you finish adjusting the page breaks in Page Break Preview (and, presumably, printing the report), click the Normal button (the first one in the cluster of three to the left of the Zoom slider) on the status bar, or choose View➪Normal on the Ribbon, or press Alt+WL to return the worksheet to its regular view of the data.
You can also insert your own manual page breaks at the cell cursor’s posi- tion by choosing Insert Page Break from the Breaks button’s drop-down menu on the Page Layout tab (Alt+PBI), and you can remove them by choos- ing Remove Page Break from this menu (Alt+PBR). To remove all manual page breaks that you’ve inserted into a report, choose Reset All Page Breaks from the Breaks button’s drop-down menu (Alt+PBA).
Printing the Formulas in a Report
There’s one more printing technique you may need every once in a while, and that’s how to print the formulas in a worksheet in a report instead of printing the calculated results of the formulas. You can check over a print- out 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 company wide.