In Excel page layout is useful for printing Excel spreadsheets correctly. With page layout view Excel lets you preview what you print.
Many of the commands you'll use to prepare your workbook for printing and PDF export can be found on the Page Layout tab. These commands let you control the way your content will appear on a printed page, including the page orientation and margin size. Other page layout options, such as print titles and page breaks, can help make your workbook easier to read.
Optional: Download our practice workbook.
Before you start modifying a workbook's page layout, you may want to view the workbook in Page Layout view, which can help you visualize your changes.
Excel offers two page orientation options: landscape and portrait. Landscape orients the page horizontally, while portrait orients the page vertically. Portrait is especially helpful for worksheets with a lot of rows, while landscape is best for worksheets with a lot of columns. In the example below, portrait orientation works best because the worksheet includes more rows than columns.
A margin is the space between your content and the edge of the page. By default, every workbook's margins are set to Normal, which is a one-inch space between the content and each edge of the page. Sometimes you may need to adjust the margins to make your data fit more comfortably on the page. Excel includes a variety of predefined margin sizes.
Excel also allows you to customize the size of your margins in the Page Setup dialog box.