Sometimes, you may need to print an Excel workbook to share or view offline. Before printing, adjust your page layout settings. Excel's Print pane makes it easy to preview and print your workbook.




Printing a Workbook in Excel

Sometimes, you may need to print an Excel workbook to view or share offline. Before printing, it is important to adjust your page layout settings. Excel makes it easy to preview and print a workbook using the Print pane.

How to Access the Print Pane

  1. Click the File tab. This will open the Backstage view.
  2. Select Print to open the Print pane.

Here, you can choose how many copies you want to print.


Click this button to print the workbook.


If you have multiple printers, select the one you want to use.


Here, you can choose to print the active sheets, the entire workbook, or a selection.


If you are printing multiple copies, you can choose whether they will be collated or uncollated.


Here, you can choose portrait or landscape orientation.


You can choose the paper size you want to use, if your printer supports this setting.


Here, you can see a preview of how your worksheets will look when printed.


Here, you can choose how to scale your worksheets for printing.


You can click the arrows to view a different page in the Preview pane.


The Zoom to Page button on the right will zoom in and out in the Preview pane.

The Show Margins button on the left will show the margins in the Preview pane.


Steps to Print a Workbook

  1. Go to the Print pane.

  2. Choose a printer.

  3. Enter the number of copies you need.

  4. Adjust any print settings if necessary.
  5. Click the Print button.

Choosing What to Print

You can decide which part of the workbook to print. Options include:

  • Active sheets (selected worksheets)

  • Entire workbook
  • Specific selection

Printing Active Sheets

  1. Select the worksheet(s) you want to print.

  2. Open the Print pane.
  3. Choose Print Active Sheets from the Print Range menu.
  4. Click Print.

Printing the Entire Workbook

  1. Open the Print pane.
  2. Select Print Entire Workbook from the Print Range menu.

  3. Click Print.

Printing a Selection

  1. Select the cells you want to print.

  2. Open the Print pane.
  3. Choose Print Selection from the Print Range menu.

  4. Click Print.

You can also set the print area in advance by selecting the cells, clicking the Page Layout tab, and choosing Set Print Area.


Adjusting Content Before Printing

Sometimes, you may need to adjust the content to fit the printed page. You can:

  • Change page orientation (Portrait or Landscape)

  • Scale content to fit the page
  • Include print titles
  • Adjust page breaks
  • Modify margins

Changing Page Orientation

  1. Open the Print pane.
  2. Choose Portrait or Landscape from the Page Orientation menu.

Fitting Content on One Page

  1. Open the Print pane.
  2. Select a scaling option from the Scaling menu (e.g., Fit All Columns on One Page).

Including Print Titles

  1. Click the Page Layout tab.
  2. Select Print Titles.
  3. In the Page Setup dialog box, choose rows or columns to repeat on every page.
  4. Click OK.

Adjusting Page Breaks

  1. Click Page Break Preview.
  2. Drag the blue dotted lines to adjust page breaks.

Modifying Margins

  1. Open the Print pane.
  2. Choose a margin size from the Page Margins menu.
  3. You can also manually adjust margins by clicking Show Margins and dragging the markers.

These steps will help you print your workbook neatly and correctly.