Print a sheet or workbook in Excel 2016 for Mac

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

  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.

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

  3. On the File menu, click Print.

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

  5. Select Show Details.

  6. 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 size, orientation, layout and paper handling options, margins, and scaling.

  • The Page Layout tab in the ribbon includes more options for page setup and printing, including page orientation and whether to print gridlines and headings.

See also

Print row and column headings and titles

Print a sheet on just one page

Scale the sheet size for printing

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×