Lesson 11: Page Layout Show /en/excel2013/worksheet-basics/content/ IntroductionMany 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. Page Layout viewBefore 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.
Page orientationExcel 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. Portrait and Landscape orientationTo change page orientation:
To format page margins: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.
To use custom margins:Excel also allows you to customize the size of your margins in the Page Setup dialog box.
To include Print Titles:If your worksheet uses title headings, it's important to include these headings on each page of your printed worksheet. It would be difficult to read a printed workbook if the title headings appeared only on the first page. The Print Titles command allows you to select specific rows and columns to appear on each page.
To insert a page break:If you need to print different parts of your workbook across separate pages, you can insert a page break. There are two types of page breaks: vertical and horizontal. Vertical page breaks separate columns, while horizontal page breaks separate rows. In our example, we'll insert a horizontal page break.
When viewing your workbook in Normal view, inserted page breaks are represented by a solid gray line, while automatic page breaks are represented by a dashed line. Viewing inserted and automatic page breaks in Normal viewTo insert headers and footers:You can make your workbook easier to read and look more professional by including headers and footers. The header is a section of the workbook that appears in the top margin, while the footer appears in the bottom margin. Headers and footers generally contain information such as page number, date, and workbook name.
Excel uses the same tools as Microsoft Word to modify headers and footers. Check out our lesson on Headers, Footers, and Page Numbers from our Word 2013 tutorial to learn more. Challenge!
/en/excel2013/printing-workbooks/content/ Which tab of the ribbon should be used when adding a header or Footer to an Excel worksheet?Add or change headers or footers in Page Layout view
On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view.
Under what ribbon can you find the header and Footer?On the Layout tab, under View, click Page Layout. On the Layout tab, under Page Setup, click Header & Footer.
What is header and Footer in Excel?A header in excel: A worksheet section appears at the top of each Excel sheet or document page. It remains constant across all the pages. For example, it can contain page no., date, title, chapter name, etc. Footer in Excel: A worksheet section appears at the bottom of each page in the Excel sheet or document.
Which tab of the ribbon contains commands to prepare a worksheet for printing?The commands in the Page Layout tab of the Ribbon are used to prepare a worksheet for printing. You can add headers and footers to a worksheet to show key information such as page numbers, the date, the file name, your name, and so on.
|