Page 60 - Excel Workbook for Dummies

07_798452 ch03.qxp 3/13/06 7:38 PM Page 43
Chapter 3: Printing Spreadsheet Reports 43
printout. To do this, you select the Gridlines and Row and Column Headings check
boxes on the Sheet tab of the Page Settings dialog box. If you also want to print the
comments, select the At the End of the Sheet or As Displayed on Sheet option on the
Comments drop-down list box on this tab.

Try It

Exercise 3-5: Changing the Print Settings for a Report
Open the Exercise3-5.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 changing various print
settings:

1. Open the Print Preview window and check out the page breaks for this three-
page report that prints all the data in the Total Sales worksheet in portrait mode.
2. Open the Page Setup dialog box from the Print Preview window and then select
the Page tab.
3. Click the Landscape option button under Orientation and then select OK to close
the Page Setup dialog box.
4. Check out the page breaks for printing the report in landscape mode. Note that
the third page now contains an “orphaned” column with the annual total sales.
5. Open the Page Setup dialog box again and then click the Page(s) Wide text box to
the immediate right of the Fit To option button in the Scaling section of the Page
tab. Replace the 1 in this text box with a 2 so that the Fit To option button is
selected with the setting 2 pages wide by 1 page tall.
Using the Fit To Scaling option to constrain the printing to a particular number of
pages rather than Adjust To option to set a specific scaling percentage is often a
much more effective way to eliminate pages with orphaned columns or rows of
data.
6. Close the Page Setup dialog box and then check out the paging in this now two-
page report. Note that the column with annual total sales is no longer orphaned.
7. Close the Print Preview window and then select Qtr1 worksheet.
8. Open the Print Preview window for this second worksheet in the Exercise 3-5.xls
workbook and then click the Margins button to turn on the margin and column
markers in Print Preview.
9. Turn on the gridlines and row and column Headings with the Page Setup dialog
box in the Print Preview window.

The display of the gridlines and row and column headings are controlled from
check boxes located on the Sheet tab of the Page Setup dialog box.
10. Zoom in on the preview of page 1 of the report by clicking the Sales table with
the magnifying glass mouse pointer.

11. Narrow column B to somewhere between 14.43 and 14.39 characters wide,
column C to somewhere between 14.29 and 14.22, and column D to somewhere
between 14.22 and 14.20 characters wide. Note the addition of the Qtr1 totals in
column E and the reduction of the report to a single page.
Refer to the Width display indicator on the left side of the status bar in the Print
Preview window when you manipulate the column markers (this indicator
changes to Left Margin, Right Margin, Top Margin, Header Margin, Bottom
Margin, and Footer Margin when you move their respective markers).