Print a worksheet in landscape or portrait orientation Show
Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More...Less 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. 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, 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 Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape. Notes:
Change the page orientation when you are ready to print
Create a template that uses landscape orientation by defaultTo 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
Top of Page 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. 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, 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. On the Page Layout tab, in the Page Setup group, click Orientation, and then click Portrait or Landscape.
Tip: To see the borders of printed pages more distinctly, you can work in Page Layout view (View tab, Workbook Views group). Change the page orientation when you are ready to print
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 in the process of editing the contents of a cell. To resolve this, press ENTER to accept the changes or ESC to cancel the changes. Create a template that uses landscape orientation by defaultTo 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
Top of Page Need more help?What should you do if you want Word to apply a coordinated set of styles to ensure there is a consistent formatting across the entire document?What should you do if you want Word to apply a coordinated set of styles to ensure there is consistent formatting across the entire document? Apply a document theme containing the styles you want.
What would you add if you wanted text or a graphic or a shape to appear behind the text on every page of a document?What would you add if you wanted text, or a graphic, or a shape to appear behind the text on every page of a document? Add a watermark to the document.
How would you break a page at a specific location and continue to the next page?On the Page Layout tab, click on Breaks, and then under Section Breaks, click Next Page. This will insert the section break, and text following the section break will begin on a new page. If you want the text to continue on the same page, under Section Breaks, click Continuous.
When you print in portrait orientation the page is wider than it is tall?Portrait – denoting a format of printed matter which is higher than it is wide. Landscape – denoting a format of printed matter which is wider than it is high. So, printing orientation that is wider than it is taller is landscape. Hence, 'landscape' is the correct answer.
|