Print a sheet or workbook

You can print entire or partial sheets and entire workbooks, one at a time or several at once. You can also print selections of several sheets at the same time. If the data that you want to print is in an Excel table, you can print just the Excel table.

Print a partial sheet, an entire sheet, or an entire workbook

Do one of the following:
- To print a partial sheet, click the sheet, and then select the range of data that you want to print.
- To print the entire sheet, click the sheet or the sheet tab.
- To print a workbook, click any of its sheets.
On the File menu, click Print.
On the Printer menu, select the printer that you want.
The default is to print all active sheets. To change what is printed, select Show Details.
In the Print drop-down menu, select the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then select Print.

Print several sheets at once

Select the sheets that you want to print.

To select	Do this
Two or more adjacent sheets	Click the tab for the first sheet. Then, hold down SHIFT and 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 COMMAND and click the tabs of the other sheets that you want to select.
All sheets in a workbook	Hold down CONTROL and click a sheet tab, and then click Select All Sheets on the shortcut menu.

Note: When multiple sheets are selected, [Group] appears in the title bar at the top of the sheet. To cancel a selection of multiple sheets in a workbook, click any unselected sheet. If no unselected sheet is visible, hold down CONTROL and click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

Print selections from several sheets at once

On each sheet, select the range of data that you want to print.
On the File menu, click Print.
Select Show Details.
In the Print drop-down menu, select Selection, and then select Print.

Print several workbooks at once

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

On the File menu, click Open.
For adjacent files, hold down SHIFT and select the name of each workbook that you want to print. Or, for nonadjacent files, hold down COMMAND and select the name of each workbook that you want to print.
On the File menu, click Print.

Print an Excel table

Click a cell within the table to activate the table.
On the File menu, click Print.
Select Show Details.
In the Print drop-down menu, select Selection, and then select Print.

Other print options

Select Show Details in the Print dialog box to print to a PDF file, or to set which pages to print, paper handling options, margins, and scaling.
The Page Layout tab in the ribbon includes more options for page setup and printing, including page orientation, paper size and whether to print gridlines and headings.