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/ Where can you see a preview of how your worksheet will look when printed including headers group of answer choices?When you select one or more sheets and then click File > Print, you'll see a preview of how the data will appear on the printout.
Which worksheet view shows you how your worksheet will look when printed?Page Layout view shows you the position of your worksheet as it will appear on a printed page. One of the features of Page Layout view is the Ruler which shows the size of the margins and allows you to drag the margins in or out to change the amount of the worksheet shown on the page.
In which view can you see the header and footer areas of a worksheet?Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time.
How do you view worksheets without headers margins and rulers?To view a worksheet without headers, margins, and rulers, use Page Layout view.
|