GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2013
  • Page Layout

Excel 2013

Single page view print copy

Page Layout

Introduction

Video: Page Layout

Launch "Page Layout" video!Watch the video (4:02).

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 Lesson 11 Practice Workbook.

Page Layout view

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.

  • To access Page Layout view, locate and select the Page Layout view command in the lower-right corner of your workbook.
    Screenshot of Excel 2013Selecting Page Layout view

Page orientation

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.

Screenshot of Excel 2013Portrait and Landscape orientation

To change page orientation:

  1. Click the Page Layout tab on the Ribbon.
  2. Select the Orientation command, then choose either Portrait or Landscape from the drop-down menu.
    Screenshot of Excel 2013Choosing a page orientation
  3. The page orientation of the workbook will be changed.

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.

  1. Click the Page Layout tab on the Ribbon, then select the Margins command.
  2. Select the desired margin size from the drop-down menu. In our example, we'll select Narrow to fit more of our content on the page.
    Screenshot of Excel 2013Choosing a pre-defined margin size
  3. The margins will be changed to the selected size.

To use custom margins:

Excel also allows you to customize the size of your margins in the Page Setup dialog box.

  1. From the Page Layout tab, click Margins. Select Custom Margins... from the drop-down menu.
    Screenshot of Excel 2013Selecting Custom Margins...
  2. The Page Setup dialog box will appear.
  3. Adjust the values for each margin and click OK.
    Screenshot of Excel 2013Setting custom page margins
  4. The margins of the workbook will be changed.
previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.