Page 55 - Excel Workbook for Dummies

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

2. Click the Margins button on the toolbar at the top of the Print Preview window to
display the markers for the left, right, top, and bottom page margins along with
those indicating the current column widths.
3. Click somewhere in the displayed Sale table with the magnifying glass mouse
pointer to zoom in on the table and its data.
4. Click the Setup button on the Print Preview toolbar to open the Page Setup
dialog box and then select the Horizontally and Vertically check boxes in the
Center on Page section on the Margins tab.
5. Select the Page 1, Spring Furniture Sale.xls heading in the Header drop-down list
box on the Header/Footer tab and then select the OK button.
6. Click the Print button on the Print Preview toolbar to close the Print Preview
window and open the Print dialog box. If you have a printer installed on your
system, make sure that its name is displayed in the Name text box and then
select OK to send the one-page report to it. Otherwise, click Cancel to close the
Print dialog box without printing the report.
7. Close the Spring Furniture Sale workbook and save the changes when an alert
dialog box appears asking you to do so (your changes to the print settings,
including the header, are then saved as part of the file).

Adjusting Page Breaks

Whereas Print Preview alerts you to all sorts of potential problems in the printed
report by showing you everything on the page as it will print, Page Break Preview only
shows you where the page breaks occur. Page Break Preview does this by drawing
lines between columns and rows in the worksheet that indicate the limits of each page
in the report. You can then manipulate the page breaks by dragging these lines to new
columns and rows.

Try It

Exercise 3-2: Paging a Report with Page Break Preview

Open the Exercise3-2.xls workbook in the Chapter 3 folder in your My Practice
Spreadsheets folder in My Documents on your hard disk (or in the Excel Workbook
folder on the workbook CD-ROM) and use it to practice using Page Break Preview:
1. Select View➪Page Break Preview on the Excel menu bar to put the Income
Analysis worksheet into Page Break Preview mode and then select OK or the
Close box to close the Welcome to Page Break Preview dialog box. Note that
Page Break Preview automatically sets the worksheet zoom factor to 60% (indi-
cated by the 60% in the Zoom combo box in the Standard toolbar).
2. Click the Zoom combo box, type 48, and press Enter to increase the zoom factor
to 48% (just a little below half-size) so that the entire Income Analysis spread-
sheet is displayed on the screen.
3. Remove the first bad page break that occurs between rows 28 and 29 where the
Northern region Net Income in row 28 on pages 1, 3, and 5 of the report is sepa-
rated from the other regions on pages 2, 4, and 6.

Return the spreadsheet to 100% (by clicking 100% on Zoom drop-down list on the
Standard toolbar), scroll down until you see the break between rows 28 and 29,
and then drag the page break line between rows 28 and 29 up two rows so that
the break now occurs between rows 26 and 27. The heading Net Income and
Northern region income figures are now printed on pages 2, 4, and 6 of the report.