Page 62 - Excel Workbook for Dummies

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

3. Center the printing of this sales table both horizontally and vertically on the page.
4. Add a footer that prints the page number centered at the bottom of the printout.
5. Add a custom header that prints your name or your company name in the Left
Section, the current date in the Center Section, and type the word CONFIDENTIAL
in the Right Section.
6. If you have access to a printer, print this worksheet; otherwise, just close
the Print Preview window and then save the workbook as Solved3-6.xls in the
Chapter 3 folder in your My Practice Spreadsheets folder before you close the
workbook.

Printing the entire workbook

Printing all the data in the entire workbook is a snap: Simply open the Print dialog box
(File➪Print or Ctrl+P) and then select the Entire Workbook option button in the Print
What section before sending the print job to the printer by selecting the OK button.

Q. How can I print data on multiple work- A. Select the tabs for all the worksheets in the
sheets without printing the entire workbook that contain data you want
workbook? printed (remember to Ctrl+click to select
multiple sheet tabs) before sending the job
to the printer.
Try It

Exercise 3-7: Printing the Entire Workbook
Open the Exercise3-7.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 printing all the sheets in a
workbook:
1. Open the Print dialog box and then select the Entire Workbook option button in
the Print What section before selecting Preview to open the Print Preview window.
2. Check out all three pages of the report in the Print Preview window. Note the
orphaned column of data on page 2 and the landscape orientation of the printing
of the column chart on page 3.
3. Select page 1 of 3 in the Print Preview window and then change the orientation of
the printing of this page from portrait to landscape. Check out the paging again
in Print Preview.
4. Center the printing of the Production Schedule on page 1 between the left and
right margin.
5. Add a footer to the report that prints the current page number and total pages
centered at the bottom of the page.
6. Preview the two pages of the report. Note that the page number footer only
appears at the bottom of page 1 with the data table and not on page 2 with the
column chart.
The footer isn’t displayed on page 2 with the chart because by default Excel
prints all charts on their own Chart sheets Full Page, leaving no room for a
header or footer (see Exercise 3-8 to see how you go about changing this setting).