Printing Workbooks

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

Choosing a print area

Before you print an Excel workbook, it's important to decide exactly what information you want to print. For example, if you have multiple worksheets in your workbook, you will need to decide if you want to print the entire workbook or only active worksheets. There may also be times when you want to print only a selection of content from your workbook.

To print active sheets:

Worksheets are considered active when selected.

  1. Select the worksheet you want to print. To print multiple worksheets, click the first worksheet, hold the Ctrl key on your keyboard, then click any other worksheets you want to select.
    Screenshot of Excel 2013Selecting multiple worksheets to print
  2. Navigate to the Print pane.
  3. Select Print Active Sheets from the Print Range drop-down menu.
    Screenshot of Excel 2013Printing active worksheets
  4. Click the Print button.
    Screenshot of Excel 2013Clicking the Print button

To print the entire workbook:

  1. Navigate to the Print pane.
  2. Select Print Entire Workbook from the Print Range drop-down menu.
    Screenshot of Excel 2013Printing the entire workbook
  3. Click the Print button.
    Screenshot of Excel 2013Clicking the Print button

To print a selection:

In our example, we'll print a selection of content related to upcoming softball games in July.

  1. Select the cells you want to print.
    Screenshot of Excel 2013Selecting a print area
  2. Navigate to the Print pane.
  3. Select Print Selection from the Print Range drop-down menu.
    Screenshot of Excel 2013Printing only the selected cells
  4. A preview of your selection will appear in the Preview pane.
    Screenshot of Excel 2013Viewing the selection in the Preview pane
  5. Click the Print button to print the selection.


    Screenshot of Excel 2013Clicking the Print button

If you prefer, you can also set the print area in advance so you'll be able to visualize which cells will be printed as you work in Excel. Simply select the cells you want to print, click the Page Layout tab, select the Print Area command, then choose Set Print Area.

Screenshot of Excel 2013Setting a print area