Microsoft Office Tutorials and References
In Depth Information
Letting Your Formulas All Hang Out
Figure 5-13:
Page 1 of
the report
after
adjusting the page
breaks in
the Page
Break
Preview
worksheet
view.
You can also insert your own manual page breaks at the cell cursor’s position
by clicking Insert Page Break on the Breaks button’s drop-down menu on the
Page Layout tab (Alt+PBI) and remove them by clicking Remove Page Break on
this menu (Alt+PBR). To remove all manual page breaks that you’ve inserted
into a report, click Reset All Page Breaks on the Breaks button’s drop-down
menu (Alt+PBA).
Letting Your Formulas All Hang Out
A basic printing technique that you may need occasionally is printing the
formulas in a worksheet 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 company-wide.
Before you can print a worksheet’s formulas, you have to display the
formulas, rather than their results, in the cells by clicking the Show Formulas
Search JabSto ::




Custom Search