By default, Microsoft Excel prints worksheets in portrait orientation (taller than wide). You can change the page orientation to landscape on a worksheet-by-worksheet basis.
Change the page orientation
-
Select the worksheet or worksheets for which you want to change the orientation.
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, select any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then select Ungroup Sheets.
-
On the Page Layout tab, in the Page Setup group, select Orientation, and then select Portrait or Landscape.
Notes:
-
If you don't have a printer set up, the Orientation option will appear dimmed, and you won't be able to select it. To resolve this, you must set up a printer. The option also appears dimmed when you're editing the contents of a cell. To resolve this, press Enter to accept the changes or Esc to cancel the changes.
-
Because you can set page orientation on a worksheet-by-worksheet basis, you might print some worksheets in a workbook in one orientation (such as portrait orientation) and other worksheets in the same workbook in the opposite orientation (such as landscape orientation). Simply set the orientation for each worksheet as appropriate, and then Print a worksheet or workbook.
-
Change the page orientation when you are ready to print
-
Select the worksheet, worksheets, or worksheet data that you want to print.
-
Select File > Print.
-
In the Page Orientation drop-down box, select Portrait Orientation or Landscape Orientation.
-
When you are ready to print, select Print.
Create a template that uses landscape orientation by default
To save time, you can save a workbook configured to print in landscape orientation as a template. You can then use this template to create other workbooks.
Create the template
-
Create a workbook.
-
Select the worksheet or worksheets for which you want to change the orientation.
How to select worksheets
To select
Do this
A single sheet
Select the sheet tab.
If you don't see the tab that you want, select the tab scrolling buttons to display the tab, and then select the tab.
Two or more adjacent sheets
Select the tab for the first sheet. Then hold down Shift while you select the tab for the last sheet that you want to select.
Two or more nonadjacent sheets
Select the tab for the first sheet. Then hold down Ctrl while you select 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.
Note: 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, select any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then select Ungroup Sheets.
-
On the Page Layout tab, in the Page Setup group, select Orientation, and then select Landscape.
Note: If you don't have a printer set up, the Orientation option will appear dimmed, and you won't be able to select it. To resolve this, you must set up a printer. The option also appears dimmed when you're editing the contents of a cell. To resolve this, press Enter to accept the changes or Esc to cancel the changes.
-
Make any other customizations as necessary.
Tip: If you want to customize several worksheets at one time, you can temporarily group the worksheets, make your changes, and then ungroup them. To group the worksheets, right-click any tab at the bottom of the worksheet. On the shortcut menu, click Select All Sheets. In the title bar, you should see the name of the workbook followed by the word [Group]. Then, change the orientation to landscape or make any other customization that you want. To turn off the grouping, right-click any tab, and then select Ungroup Sheets (or just select another worksheet tab).
-
Select the File tab.
-
Select Save As, then select the location where you want to save your worksheet. For example, select This PC or Browse, and then select Desktop.
-
In the Enter file name here box, type the name that you want to use for the template.
-
In the Save as type box, select Excel Template (*.xltx), or select Excel Macro-Enabled Template (*.xltm) if the workbook contains macros that you want to make available in the template.
-
Select Save.
The template is automatically sent in the Templates folder.
To use the template to create a workbook, do the following:
-
Select File > New.
-
Select Personal.
-
Select the icon or name of your saved template.
-
