Print a worksheet or workbook

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.

  1. 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.

Top of Page Top of Page

Print several worksheets at once

  1. Select the worksheets that you want to print.

ShowHow to select multiple worksheets

To select Do this
A single sheet

Click the sheet tab.

Active sheet tab

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 (shortcut menu: A menu that shows a list of commands relevant to a particular item. To display a shortcut menu, right-click an item or press SHIFT+F10.).

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.

  1. 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.

Top of Page Top of Page

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.

  1. Hold down CTRL and click the name of each workbook that you want to print.
  2. On a computer that is running Windows Vista    
    • Right-click the selection, and then click Print.

On a computer that is running Microsoft Windows XP    

  • In the Open dialog box, click Tools, and then click Print.

Top of Page Top of Page

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.

  1. Under Print what, select Table.

Top of Page Top of Page

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.

  1. In the Name box, select the printer on which you want to print the file.
  2. Select the Print to file check box, and then click OK.
  3. 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.

Top of Page Top of Page

 
 
Applies to:
Excel 2007