Page 56 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 39
Chapter 3: Printing Spreadsheet Reports 39

4. Adjust the page break between pages 1 and 3 and pages 2 and 4 so that only the
Qtr 1 income figures are printed on pages 1 and 2 and all the Qtr 2 income data
are together on pages 3 and 4.
Scroll up so you can see the column header in the worksheet and then drag the
page break line between columns G and H to the left so that the break now
occurs between columns E and F, putting all the Qtr 2 figures on pages 3 and 4 of
the report.
5. Adjust the page break between pages 3 and 5 and 4 and 6 so that only the Qtr 2
income figures are printed on pages 3 and 4 of the report.

6. Adjust the page break between pages 5 and 7 and 6 and 8 so that only the Qtr 3
income figures are printed on pages 5 and 6 of the report.
7. Choose View➪Normal to get out of Page Break Preview mode. Note that the page
breaks continue to appear as dotted lines in normal spreadsheet view.
8. Verify the pages of the report in Print Preview.
9. Center the printing between the left and right margins on each page of the
report.
Select the Horizontally check box in the Center on Page section on the Margins
tab of the Page Setup dialog box to center the printing between the left and right
margins.
10. Remove the column and row gridlines from the report by removing the check
mark from the Gridlines check box on the Sheet tab of the Page Setup dialog box.
11. Preview all eight pages of the final report using the Page Down key to advance to
the next page and the Page Up key to return to the previous page (make sure
that you’ve zoomed out on the previewed page before pressing these keys, or
you only end up scrolling around the same page).
12. When you’re sure that all the pages of the report are okay, print the report if you
have access to a printer; otherwise, close the Print Preview window and then
save the revised Income Analysis workbook file as Solved3-2.xls in the Chapter 3
folder before you close the workbook.

Adding Custom Headers and Footers

In Exercise 3-1, you added a canned or ready-made header to your simple one-page
report. This header centered the page number between the left and right margins and
aligned the name of the workbook file with the right margin inside the top margin of
the printed page. In addition to these types of ready-made headers and footers, Excel
enables you to create custom headers and footers for your reports.

To add a custom header or footer to a report, you insert codes (selected from buttons
like those that appear in the Header dialog box shown in Figure 3-1) that retrieve infor-
mation about the report or workbook file that you can mix with stock text (such as the
company or department name) in one of three sections:
Left Section for information to be left-aligned against the page’s left margin
Center Section for information to be centered between the left and right
margins
Right Section for information to be right-aligned against the page’s right
margin