Page 58 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 41
Chapter 3: Printing Spreadsheet Reports 41
To change the font or assign an attribute to the codes or stock text you add to a
section of a custom header or footer, drag through them, and then click the Font
button. Choose the font, font style, and attributes in the Font dialog box.
4. Insert the filename in the Center Section of the custom header and make its text
9-point bold italic Arial.
5. Insert the stock phrase PRELIMINARY (in all caps) in the Right Section of the
custom header: Make this stock text 9-point Times New Roman and then select
OK to close the Header dialog box.
6. Make the ready-made footer with the current page and total page numbers
10-point bold Arial.
To customize the font settings for a ready-made header or footer, open the
Header or Footer dialog box with the Customize Header or Customize Footer
button, respectively, and then select the codes or stock text before you click the
Font button.
7. Close the Footer dialog box and the Page Setup dialog box and then check out
your custom header and footer in the Print Preview window.

8. If the header and footer check out, close the Print Preview window and then save
the revised Income Analysis workbook file as Solved3-3.xls in the Chapter 3 folder
and close the workbook.

Adding Print Titles to a Report

In Excel reports, you use Print Titles to print the column and row headings from the
worksheet on each and every page. If you don’t bother to add Print Titles to multi-page
reports, only the first pages of the report contain the headings that identify the related
data, and your readers have no way of identifying the data on the later pages of the
report.

Try It

Exercise 3-4: Adding Print Titles to a Report
Open the Exercise3-4.xls workbook in the Chapter 3 folder in your My Spreadsheets (or
My Practice Spreadsheets) folder or on the workbook CD-ROM and use it to practice
adding Print Titles to a report:
1. Open the Bo-Peep Client List in the Print Preview window and then preview each
of its four pages. Note that page 2 lacks the spreadsheet title and the column
headings with the field names, page 3 lacks the row headings with the case num-
bers, and page 4 lacks the spreadsheet title as well as the identifying column and
row headings.
2. Close the Print Preview window and then open the Page Setup dialog box
(File➪Page Setup) and select the Sheet tab.
You can only assign rows and columns of the spreadsheet from the Sheet tab of
the Page Setup dialog box when you open this dialog box in the normal work-
sheet window. The Rows to Repeat at Top and Columns to Repeat at Left text
boxes in the Print Titles section on the Sheet tab are grayed out and unavailable
when you open the Setup dialog box with the Setup button in the Print Preview
window.