Tutorial 1: Working with Excel Page Breaks

When printing multi-page spreadsheets in Excel, you may have come across page breaks which appear to be in the wrong place. For example, the default page break may force a particular row onto the next page. These breaks are set automatically by Excel and can be seen as horizontal and vertical dashed lines in Normal View.

In these situations, manual page breaks can be set to override the defaults and give you more control over how the spreadsheets looks when printed.

In Excel 2010 and later, setting manual page breaks is easier than ever. Using the Page Break Preview button shown below, you can add and remove page breaks as well as drag page breaks to new locations.

 

excel-page-breaks

 

To access Page Break Preview:

  1. On the Workbook Views group of the Views tab, choose Page Break Preview.

To exit Page Break Preview:

  1. On the Workbook Views group of the Views tab, choose Normal.

To add a page break(s) in Page Break Preview:

  1. Right-click a cell below and to the right of the new page break(s).
  2. From the shortcut menu, choose Insert Page Break.

To remove page break(s) in Page Break Preview:

  1. Right-click the cell below and to the right of the page break(s).
  2. From the shortcut menu, choose Remove Page Break.

To move page breaks in Page Break Preview:

  1. Drag the page break to its new location.

Note: You can only drag page breaks when the double-headed arrow mouse pointer appears.