Printing in Excel

In this lesson I will show you how to print an Excel worksheet and edit all kinds of print settings to meet your Excel printing needs.

How to print a worksheet in Excel

Complete the following steps in order to print a worksheet in Excel.

1. Click on the File tab on the top left-hand corner, and afterwards select Print.

File tab on top left-hand corner
File tab on top left-hand corner
Print option under File tab
Print option under File tab

2. A preview of the format in which the Excel worksheet will be printed will appear on the right-side of the screen. You can preview the other pages by clicking Next Page or Previous Page at the bottom of the window.

Format preview of Excel worksheet
Format preview of Excel worksheet
 3. Click the Print button located on the top of the Settings pane to print the worksheet.
Print button on top of Settings pane
Print button on top of Settings pane

Printing only a specific selection, sheet or page in Excel

If you only want to print specific sections of an Excel worksheet instead of the entire document, you can do the following:

1. Select the range of cells you want to print with your cursor.

Select the range of cells you want in your document
Select the range of cells you want in your document

2. Click on the File tab on the top left-hand corner, and afterwards select Print.

File tab on top left-hand corner
File tab on top left-hand corner
Print option under File tab
Print option under File tab

3. Select the option Print Selection under Settings.

Print Selection option under Settings pane
Print Selection option under Settings pane

4.  Click the Print button located on top of the Settings pane to print the selected section of the Excel worksheet.

Print button on top of Settings pane
Print button on top of Settings pane

Note that it is also possible to only print the Active Sheets or to print the Entire Workbook. Fill in the two empty boxes near the top of the Settings pane to only print specific pages of your document.

Manually select which pages to print under Settings
Manually select which pages to print under Settings

Printing multiple copies of your Excel sheet

If you want to print multiple copies of your workbook, you can easily do that too by changing the Copies number in the printing pane as follows:

1. Click on the File tab on the top left-hand corner, and afterwards select Print.

2. Look for the Copies box located next to the Print button, and using the arrows select the desired amount of copies.

Copies box next to Print button
Copies box next to Print button

3. If a worksheet consists of multiple pages you have the option to print Collated or Uncollated.

  • Uncollated prints X amount of copies of page 1, X amount of page 2, and so on.
  • Collated will print the entire worksheet and repeat this process X amount of times.  
Settings pane with option to print Collated or Uncollated
Settings pane with option to print Collated or Uncollated

Changing the Page margins for printing

Complete the following steps adjust the page margins when printing your Excel worksheet.

1. Click on the File tab on the top left-hand corner, and afterwards select Print.

2. Choose one of the predefined margins (Normal, Wide, Narrow) from the Margins drop-down list under the Settings pane.

Adjust the document Margins in the Settings pane
Adjust the document Margins in the Settings pane

3. You have the option to create your own margin boundaries by either selecting Custom Margins on the bottom of the Margins drop-down list, or by selecting Show Margins in the bottom-right corner of the screen.

Show Margins option to manually adjust document Margins
Show Margins option to manually adjust document Margins

Note that selecting Show Margins requires you to set your margins manually, whereas you input values to set your margins when selecting Custom Margins from the Margins drop-down.

Rate this post