There are many choices you can make when printing an Excel workbook. You can choose what parts of a workbook to print and how the data fits on the page.

In this lesson, you will learn how to print worksheets, workbooks, andselections of cells. You will also learn how to prepare for printing by modifyingpage orientation, scale, margins, Print Titles, and page breaks.

In previous versions of Excel, there was a Print Preview option that allowed you to preview and modify the workbook before printing. You may have noticed that this feature seems to be gone in Excel 2010. It actually has not disappeared; it has just been combined with the Printwindow to create the Print pane, which is located in Backstage view.

To Print Active Sheets:

1. Select the worksheets you want to print. To print multiple worksheets, click on the first worksheet, hold down the Ctrl key, then click on the other worksheets you want to select.
   Selecting worksheets to print
2. Click the File tab.
3. Select Print to access the Print pane.
4. Select Print Active Sheets from the print range drop-down menu.
   Selecting the Print Active Sheets command
5. Click the Print button.

To Print the Entire Workbook:

1. Click the File tab.
2. Select Print to access the Print pane.
3. Select Print Entire Workbook from the print range drop-down menu.
   Selecting the Print Entire Workbook command
4. Click the Print button.

To Print a Selection, or Set the Print Area:

1. Select the cells that you want to print.
   Selected cells to print
2. Click the File tab.
3. Select Print to access the Print pane.
4. Select Print Selection from the print range drop-down menu.
   Selecting the Print Selection command
5. You can see what your selection will look like on the page in Print Preview.
   Print Preview
6. Click the Print button.
   

To Change Page Orientation:

1. Click the File tab.
2. Select Print to access the Print pane.
3. Select either Portrait Orientation or Landscape Orientation from the orientation drop-down menu.
   Orientation drop-down menu
4. Your page orientation is changed.
   Portrait Orientation in Print Preview
   Landscape Orientation in Print Preview
    

To Fit a Worksheet on One Page:

1. Click the File tab.
2. Select Print to access the Print pane.
3. Select Fit Sheet on One Page from the scaling drop-down menu.
   Selecting the Fit Sheet on One Page command
4. Your worksheet is reduced in size until it fits on one page. Remember that if it is scaled too small it might be difficult to read.

To Modify Margins While in Print Preview:

1. Click the File tab.
2. Select Print to access the Print pane.
3. Click on the Show Margins button. Your margins will appear.
4. Hover your mouse over one of the margin markers  until the double arrow  appears.
5. Click and drag the margin to your desired location.
6. Release the mouse. The margin is modified.
   Modifying margins while in Print Preview

   To Use Print Titles:

   Imagine how difficult it would be to read a worksheet if the column and row headings only appeared on the first page. The Print Titles command allows you to select specific rows and columns to appear on each page.

   1. Click the Page Layout tab.
   2. Select the Print Titles command.
      Selecting the Print Titles command
   3. The Page Setup dialog box appears. Click the icon at the end of the Rows to repeat at top field.
      Clicking on icon
   4. Your mouse becomes the small selection arrow . Click on the rows you want to appear on each printed page. The Rows to repeat at top dialog box will record your selection.
      Clicking on row 1
   5. Click the icon at the end of the Rows to repeat at top field.
      Clicking on icon
   6. Repeat for Columns to repeat at left, if necessary.
   7. Click OK. You can go to Print Preview to see how each page will look when printed.

   To Insert a Break:

   1. Click the Page Layout tab.
   2. Determine the placement of the break by clicking on the row below, cell below, or column to the right of where you want the break to appear. For example, select column C and a break will appear after column B.
      Selecting the column to the right of where the break will appear
   3. Select the Insert Page Break command from the Breaks drop-down menu.
      Selecting the Insert Page Break command
   4. The break is inserted. You can go to Print Preview to confirm it appears in the correct place on the page.