You can print entire or partial worksheets and workbooks, one at a time, or several at once. And if the data that you want to print is in a Microsoft Office Excel table, you can print just the Excel table.

You can also print a workbook to a file instead of to a printer. This is useful when you need to print the workbook on a different type of printer from the one that you originally used to print it.What do you want to do?

Print a partial or entire worksheet or workbook

  1. Do one of the following:
    • To print a partial worksheet, click the worksheet, and then select the range of data that you want to print.
    • To print the entire worksheet, click the worksheet to activate it.
    • To print a workbook, click any of its worksheets.
  2. Click Microsoft Office Button button image, and then click Print.

    Keyboard shortcut You can also press CTRL+P.

  3. Under Print what, select an option to print the selection, the active sheet or sheets, or the entire workbook.

    Note If a worksheet has a defined print area, Excel will print only the print area. If you don't want to print a defined print area, select the Ignore print areas check box.

Tip To print quickly or to preview the printout before you print, click Microsoft Office Button button image, click the arrow next to Print, and then click Quick Print or Print Preview.

Print several worksheets at once

  1. Select the worksheets that you want to print.

    How to select multiple worksheets

    To select Do this
    A single sheet Click the sheet tab.

    sheet tabs showing sheet2 selected

    If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.

    tab scrolling buttons

    Two or more adjacent sheets Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.
    Two or more nonadjacent sheets Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
    All sheets in a workbook Right-click a sheet tab, and then click Select All Sheets on the shortcut menu .

    Tip When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

  2. Click Microsoft Office Button button image, and then click Print.

    Keyboard shortcut You can also press CTRL+P.

Tip To print quickly or to preview the printout before you print, click Microsoft Office Button button image, click the arrow next to Print, and then click Quick Print or Print Preview.

Print several workbooks at once

All workbook files that you want to print must be in the same folder.

  1. Click Microsoft Office Button button image, and then click Open.

    Keyboard shortcut You can also press CTRL+O.

  2. Hold down CTRL and click the name of each workbook that you want to print.
  3. In the Open dialog box, click Tools, and then click Print.

Print an Excel table

  1. Click a cell within the table to activate the table.
  2. Click Microsoft Office Button button image, and then click Print.

    Keyboard shortcut You can also press CTRL+P.

  3. Under Print what, select Table.

Print a workbook to a file

  1. Click Microsoft Office Button button image, and then click Print.

    Keyboard shortcut You can also press CTRL+P.

  2. In the Name box, select the printer on which you want to print the file.
  3. Select the Print to file check box, and then click OK.
  4. In the Print to File dialog box, under Output File Name, type a name for the file that you want to print.

Note If you print a workbook to a file so that you can later print the file on a different type of printer from the one that was originally used to print the document, the page breaks and font spacing may change.



See also: