Print a worksheet or workbook

You can print entire or partial worksheets and workbooks, either one at a time or several at once. Also, if the data that you want to print is in a Microsoft Excel table, you can print just the Excel table.

1. Print one or several worksheets

Select the worksheets that you want to print.
Select File > Print, or press CTRL
Optionally adjust Settings, then select the Print button.

2. Print one or several workbooks

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

Select File > Open.
Hold down CTRL click the name of each workbook to print, and then select Print.

3. Print all or part of a worksheet

Select the worksheet, then select the range of data to be printed.
Select File, then click Print.
Under Settings, select the arrow next to Print Active Sheets and select the appropriate option.

4. Print an Excel table

Select a cell within the table to enable the table.
Select File, and then select Print.
Under Settings, select the arrow next to Print Active Sheets and select Print Selected Table.
Select Print.