Printing Workbooks

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

Fitting and scaling content

On occasion, you may need to make small adjustments from the Print pane to fit your workbook content neatly onto a printed page. The Print pane includes several tools to help fit and scale your content, such as scaling and page margins.

To fit content before printing:

If some of your content is being cut off by the printer, you can use scaling to fit your workbook to the page automatically.

  1. Navigate to the Print pane. In our example, we can see in the Preview pane that our content will be cut off when printed.
    Screenshot of Excel 2013Viewing a cut off worksheet in the Preview pane
  2. Select the desired option from the Scaling drop-down menu. In our example, we'll select Fit Sheet on One Page.
    Screenshot of Excel 2013Fitting a worksheet onto one page
  3. The worksheet will be condensed to fit onto a single page.
    Screenshot of Excel 2013The scaled worksheet
  4. When you're satisfied with the scaling, click Print.
    Screenshot of Excel 2013Clicking the Print button

Keep in mind that worksheets will become more difficult to read as they are scaled down, so you may not want to use this option when printing a worksheet with a lot of information.

To modify margins in the Preview pane:

Sometimes you may only need to adjust a single margin to make your data fit more comfortably. You can modify individual page margins from the Preview pane.

  1. Navigate to the Print pane, then click the Show Margins button in the lower-right corner.

    Screenshot of Excel 2013Showing the margins
  2. The page margins will appear in the Preview pane. Hover the mouse over one of the margin markers until the cursor becomes a double arrow . In our example, we'll modify the left margin to fit an additional column on the page.

    Screenshot of Excel 2013Hovering the mouse over a margin
  3. Click, hold, and drag the mouse to increase or decrease the margin width.
    Screenshot of Excel 2013Decreasing the margin width
  4. Release the mouse. The margin will be modified. In our example, we were able to fit an additional column on the page.

    Screenshot of Excel 2013The new margin width