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.

Newer versions Office 2011



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

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

2. On the File menu, click Print.

3. On the Printer menu, select the printer that you want.

4. The default is to print all active sheets. To change what is printed, select Show Details.

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

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

2. On the File menu, click Print.

3. On the Printer menu, select the printer that you want.

4. Select Show Details.

5. In the Print drop-down menu, select Active Sheets, and then select Print.

Print selections from several sheets at once

1. On each sheet, select the range of data that you want to print.

2. On the File menu, click Print.

3. Select Show Details.

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

1. On the File menu, click Open.

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

3. On the File menu, click Print.

Print an Excel table

1. Click a cell within the table to activate the table.

2. On the File menu, click Print.

3. Select Show Details.

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

See also

Print headings or titles on every page

Print a sheet on just one page

Scale the sheet size for printing

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

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

2. On the File menu, click Print.

3. On the Printer pop-up menu, select the printer that you want.

4. Next to Print What, click the option that corresponds to what you want to print (Selection, Active Sheets, or Entire Workbook) and then click Print.

Print several sheets at once

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

2. On the File menu, click Print.

3. On the Printer pop-up menu, select the printer that you want.

4. Next to Print What, click Active Sheets, and then click Print.

Print selections from several sheets at once

1. On each sheet, select the range of data that you want to print.

2. On the File menu, click Print.

3. Next to Print What, click Selection, and then click Print.

Print several workbooks at once

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

1. On the File menu, click Open.

2. Hold down CONTROL and click the name of each workbook that you want to print.

3. On the File menu, click Print.

Print an Excel table

1. Click a cell within the table to activate the table.

2. On the File menu, click Print.

3. Next to Print What, click Selection, and then click Print.

Tip: The Layout tab in the ribbon includes more options for page setup and printing, including page orientation and headers and footers.

See also

Print headings or titles on every page

Preview pages before you print

Print with landscape orientation