Printing

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

To change page orientation:

Change the page orientation to portrait to orient the page vertically and landscape to orient the page horizontally. Portrait is useful for worksheets needing to fit more rows on one page, while landscape is useful for worksheets needing to fit more columns on one page.

  1. Click the File tab.
  2. Select Print to access the Print pane.
  3. Select either Portrait Orientation or Landscape Orientation from the orientation drop-down menu.
    Orientation drop-down menu Orientation drop-down menu
  4. Your page orientation is changed.
    Portrait Orientation Portrait Orientation in Print Preview
    Landscape Orientation Landscape Orientation in Print Preview

To fit a worksheet on one page:

  1. Click the File tab.
  2. Select Print to access the Print pane.
  3. Select Fit Sheet on One Page from the scaling drop-down menu.
    Selecting the Fit Sheet on One Page command Selecting the Fit Sheet on One Page command
  4. Your worksheet is reduced in size until it fits on one page. Remember that if it is scaled too small, it might be difficult to read.

To modify margins while in Print Preview:

The margins of your worksheet may need to be adjusted to make data fit more comfortably on the printed page. You can adjust the margins in Print Preview.

  1. Click the File tab.
  2. Select Print to access the Print pane.
  3. Click the Show Margins button. Your margins will appear.
  4. Hover your mouse over one of the margin markers until the double arrow appears.
  5. Click and drag the margin to your desired location.
  6. Release the mouse. The margin is modified.
    Modifying margins while in Print Preview Modifying margins while in Print Preview