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
- 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.
Top of Page
Print several worksheets at once
- Select the worksheets that you want to print.
How to select multiple worksheets
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.
Top of Page
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.
Top of Page
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.
Top of Page
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.
Top of Page
