Page 61 - Excel Workbook for Dummies

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

12. Turn off the gridlines and row and column headings in the Print Preview window;
add a footer that prints the page number centered and the worksheet name
right-aligned.
13. If you have access to a printer, print this worksheet; otherwise, just close the
Print Preview window and then save the workbook as Solved3-5.xls in the
Chapter 3 folder in your My Practice Spreadsheets folder before you close
the workbook.

Printing All or Part of the Workbook

As noted in the previous section on default print settings, the Print Area that defines
which cell ranges are included in the printout consists of whatever worksheet or work-
sheets that you’ve selected at the time of printing. Many times you need to reduce the
Print Area to just a range of cells within the active worksheet or to increase it to
include the data on all the worksheets in the entire workbook. The exercises in this
section give you practice in printing not only Print Areas of different sizes but also
printouts that include the contents of formulas in the spreadsheet (as opposed to
their calculated values) and charts that you’ve created (see Chapter 14 for practice on
charting spreadsheet data).
If you want to print all the data on the active worksheet using the print settings cur-
rently in effect for that sheet, simply click the Print button on the Standard toolbar:
Excel then sends the print job directly to the default printer without ever opening the
Print dialog box.

Printing a range of cells

Many times you only need to print a particular table or list of data on the active work-
sheet (as opposed to all the data on the sheet). To do this, select the cell range or
ranges that encompass this data in the active worksheet and then click the Selection
option button in the Print What section in the Print dialog box (File➪Print or Ctrl+P).
Then send the print job to the printer by selecting OK.

If you have a table or list in a worksheet whose updated data you need to print regu-
larly, name the range and use the Go To feature (as covered in Chapter 4) to quickly
select it for printing.

Try It

Exercise 3-6: Printing a Particular Range of Worksheet Data

Open the Exercise3-6.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 just a table of data:
1. Select the cell range A1:R15 (note that several of the rows and columns in the
worksheet are hidden) and then open the Print dialog box.
2. Click the Selection option button and then click the Preview button at the
bottom of the Print dialog box to verify that only the Sales table, and not the
embedded column chart immediately beneath it in the 2006 Sales worksheet,
will be printed.