Print one or several worksheets

  1. Select the worksheets that you want to print.

  2. Click File > Print. You can also press Ctrl+P.

  3. Click the Printbutton or adjust Settingsbefore you click the Printbutton.

Print one or several workbooks

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

  1. Click File > Open. You can also press Ctrl+O.

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

  3. Right-click the selection, and click Print.

Print a part of a worksheet

  1. Click the worksheet, and select the range of data that you want to print.

  2. Click File> Print. You can also press Ctrl+P.

  3. Under Settings, click the arrow next to Print Active Sheets and select Print Selected Table.

  4. Click the Print button. If a worksheet has defined print areas, Excel will print only those print areas. If you don't want to print only a defined print area, check the Ignore print areabox.

Print an Excel table

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

  2. Click File>Print. You can also press Ctrl+P.

  3. Under Settings, click the arrow next to Print Active Sheets and select Selected Table.

  4. Click the Print button.

Print gridlines in a worksheet

  1. Select the worksheet or worksheets that you want to print.

  2. On the Page Layouttab, in the Sheet Optionsgroup, check the Printbox under Gridlines.

  3. Click File> Print. You can also press Ctrl+P.