Printing in Excel can sometimes be complicated. Learn about Excel printing, including setting the right print area, in this lesson.


Video: Printing in Excel 2010

Launch video!Watch the video (4:55).

In previous versions of Excel, there was a Print Preview option that allowed you to preview and modify a workbook before printing. You may have noticed that this feature seems to be gone in Excel 2010. It actually has not disappeared; it has just been combined with the Print window to create the Print pane, which is located in Backstage view.

Optional: You can download this example for extra practice.

To view the Print pane:

  1. Click the File tab. This takes you to Backstage view.
  2. Select Print. The Print pane appears, with the print settings on the left and Print Preview on the right.

Click the buttons in the interactive below to learn about the Print pane.

labeled graphic

Show Margins/Zoom to Page

The Zoom to Page button is on the right. Click it to zoom in and out in the Preview pane.

The Show Margins button is to the left of the Zoom to Page button. Click it to adjust the margins of your workbook.


Click the arrows to view a different page in the Print Preview area.

Print Preview

This allows you to see how your worksheets will look when printed.


Choose how to scale your worksheets for the printed page. You can scale worksheets at their actual size, to fit all on one page, to fit all the columns on one page, or to fit all the rows on one page.


You can adjust the margins here. This is useful if parts of your worksheets are being cut off by the printer.

Paper Size

Choose the paper size you want your printer to use.


Here, you can choose portrait or landscape orientation.


If you are printing multiple copies, choose whether you want the copies collated or uncollated.

One Side/Both Sides

Choose whether to print on one side or both sides of the paper.

Print Range

Choose whether to print the active sheets, entire workbook, or a selection of cells.


You may need to select the printer you want to use if your computer is connected to multiple printers.

Print Button

Click the Print button when you are ready to print.