Print a partial or entire worksheet or workbook
- 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.
- Click Microsoft Office Button
, and then click Print.Keyboard shortcut You can also press CTRL+P.
- 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 , click the arrow next to Print, and then click Quick Print or Print Preview.
Print several worksheets at once
- Select the worksheets that you want to print.How to select multiple worksheets
To select Do this A single sheet Click the 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.
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.
- Click Microsoft Office Button
, 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 , 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.
- Click Microsoft Office Button
, and then click Open.Keyboard shortcut You can also press CTRL+O.
- Hold down CTRL and click the name of each workbook that you want to print.
- 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.
Print an Excel table
- Click a cell within the table to activate the table.
- Click Microsoft Office Button
, and then click Print.Keyboard shortcut You can also press CTRL+P.
- Under Print what, select Table.
Print a workbook to a file
- Click Microsoft Office Button
, and then click Print.Keyboard shortcut You can also press CTRL+P.
- In the Name box, select the printer on which you want to print the file.
- Select the Print to file check box, and then click OK.
- 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.