Page 59 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 42
42 Part I: Creating Spreadsheets

3. Click the Rows to Repeat at Top text box and then click row 2 of the Client List.
Note that the Page Setup dialog box temporarily collapses down to just Rows to
Repeat at Top text box as you click row 2 in the worksheet. A marquee now
appears around this row in the worksheet and that its row range, $2:$2, appears
in the text box on the Sheet tab.

4. Click the Columns to Repeat at Left text box and then click somewhere in column
A in the Client List — a marquee now appears around column A in the worksheet
and the column range. $A:$A appears in this text box on the Sheet tab.
5. Click the Print Preview button on the Sheet tab in the Page Setup dialog box and
then page through each of the four pages in the Print Preview window. Now the
column headings with the field names for the list and the row headings with the
case numbers appear at the top and at the left of every page in the report.
6. Close the Print Preview window and then save the revised Bo-Peep Client List
workbook file as Solved3-4.xls in the Chapter 3 folder and close the workbook.

Modifying the Print Setting for a Report

Regardless of what type of printer you use, Excel has a number of default print settings
that it automatically puts into effect when you first print a spreadsheet. These print
settings include

Portrait rather than landscape orientation for the printing (so that the printing
runs with the shorter width of the page rather than with the longer length)
Printing at 100% of normal size
Print quality medium (on printers that support different print quality modes)
Letter (8.5 x 11 in.) paper size
Top and bottom margins of 1 inch
Left and right margins of 0.75 inch
Header and footer margins of 0.5 inch (with no header or footer defined)
No printing of the column and row gridlines that define the cells in the
worksheet
No printing of the column letters and row numbers associated with the cells
within the Print Area in the worksheet
No printing of the comments attached to cells included in the Print Area
(see Chapter 4 for more on comments)
Printing of error values returned by formulas as they appear in the worksheet
(see Chapter 5 for more on error values)
Paging order down the rows of the Print Area and then across the columns
Printing a single copy of all the pages generated from a Print Area that includes
all the data in the active worksheet(s)

Many times you may find that you can solve minor paging problems in a report simply
by modifying the orientation of the printing, the percentage of normal size on the Page
tab of the Page Settings dialog box, or the margin settings on the Margins tab.
If your intention is simply to produce a facsimile of the worksheet for reviewing its
data, you should include the worksheet gridlines and column and row headings in the