Excel 2010

To change page orientation:

Change the page orientation to Portrait to orient the page vertically or 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
4. Your page orientation is changed.
   Portrait Orientation in Print Preview

   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
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