Skip to main content

Print a worksheet or workbook

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

You can also print a workbook to a file instead of a printer. This is useful when you need to print the workbook on a different type of printer from the one that you originally used to print it.

Before you print

Before you print anything in Excel, remember that there are many options available for an optimal print experience. Such as preview pages, set page margins, add headers and footers ...

Print one or several worksheets

  1. Select the worksheets that you want to print. You can select multiple worksheets by holding down CTRL and clicking on the worksheet names.
  2. Select File > Print, or press CTRL+P.
  3. Select the Print button or adjust Settings before you select the Print button.

Print one or several workbooks

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

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

Print all or part of a worksheet

  1. Click the worksheet, and then select the range of data that you want to print.
  2. Select File, and then click Print, or press Ctrl+P.
  3. Under Settings, select the arrow next to Print Active Sheets and select the appropriate option.
  4. Select Print.

Print an Excel table

  1. Select a cell within the table to enable the table.
  2. Select File, and then select Print, or press Ctrl+P.
  3. Under Settings, select the arrow next to Print Active Sheets and select Print Selected Table.
  4. Select Print.

Print a workbook to a file

  1. Select File, and then select Print, or press Ctrl+P.
  2. Under Printer, select Print to File.
  3. Select Print.
  4. In the Save Print Output As dialog box, enter a file name and then select OK. The file will be saved in your Documents folder

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>