Print landscape or portrait

You can change the orientation of a worksheet page directly in the worksheet, so that you can see how your worksheet will be printed while you work, or you can select the orientation in the Printer Properties dialog box when you are ready to print.What do you want to do?

Change the page orientation of worksheets while you work

Change the page orientation in the Printer Properties dialog box

Change the page orientation of worksheets while you work

1. Select the worksheet or worksheets for which you want to change the orientation.

   How to select worksheets

   To select	Do this
   A single sheet	Click the sheet tab. If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.
   Two or more adjacent sheets	Click the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.
   Two or more nonadjacent sheets	Click the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.
   All sheets in a workbook	Right-click a sheet tab, and then click Select All Sheets on the shortcut menu .

   Tip When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.

2. On the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.

   

Change the page orientation in the Printer Properties dialog box

1. Do one of the following:
   • To print a partial worksheet, click the worksheet, and then select the range of data that you want to print.
   • To print the entire worksheet, click the worksheet to activate it.
   • To print a workbook, click any of its worksheets.
2. Click Microsoft Office Button , and then click Print.

   Keyboard shortcut You can also press CTRL+P.

3. Under Printer, click Properties.
4. On the Layout tab, under Orientation, click Portrait or Landscape.

   Note The name of the tab that displays the orientation options varies, depending on the printer that you are using.

5. Click OK.
6. In the Print dialog box, select any other options that you want, and then click OK.

See also:

• Preview worksheet pages before printing
• Print a worksheet or workbook