Page Break in Excel

What is Page Break

A page break is used to determine where the printed page ends and where begins the next one, so the content before the page break will be printed on one page and after the page break on another.

Page Break Preview

You can preview how many pages will be printed by choosing Page Break Preview. You can find it in two places.

  1. VIEW >> Workbook Views >> Page Break Preview.
  2. In Status Bar.

Each page is enumerated, so you will know which part of the worksheet will be printed on which page.

Manual and Automatic Page Breaks

We can distinguish two types of page breaks.

Automatic

These page breaks are created automatically by Excel, so when you print your worksheet without changing their position these page breaks will be used. Automatic page breaks are specified by dashed lines.

As you can see the automatic page break was inserted between column G and column H. This means that the table will be printed from cell A1 to G5 on the first page and from cell H1 to H5 on the second page.

Manual

Manual page breaks are the ones created by the user. You can create a manual page break in two ways:

  1. Inserting a new one.
  2. Dragging an automatic page break. It will change it to the manual page break.

Manual page breaks use solid lines.

Insert a Page Break

In order to insert a new page break, go to PAGE LAYOUT >> Page Setup >> Breaks >> Insert Page Break.

If you want to print names and the first three months on the first page, and the next four months on the second, select cell E6 and click Insert Page Break.

Both vertical and horizontal page breaks are inserted:

  1. Vertical at the left edge of the active cell.
  2. Horizontal at the top edge.

In our example, it will split the table into two parts.

Move a Page Break

You can move both inserted and automatic page breaks. In our example, the automatic page breaks probably are not where you want them to be because you can easily fit the last column on the same page as the other ones.

Change the view to Page Break View and move the page break between columns G and H one column to the left, so it will be between columns H and I.

Remove a Page Break

In order to remove a page break, first, choose Page Break Preview and then place your cursor in the cell that is adjacent to the page break from the left or top edge. Take a look at the following example.

Now, go to PAGE LAYOUT >> Page Setup >> Breaks >> Remove Page Break. It will remove the vertical page break between columns C and D, and the horizontal page break between rows 3 and 4.

CAUTION

You cannot delete automatic page breaks.

Hide or show Page Breaks

If you find page breaks annoying you can hide them. Go to FILE >> Options >> Advanced and under the Display options for this worksheet uncheck Show page breaks.

Reset Page Break

If you want to reset all the page breaks you inserted, go to PAGE LAYOUT >> Page Setup >> Breaks >> Reset All Page Breaks.

All manually inserted page breaks will be removed and the automatic page breaks will appear as they were present at the beginning.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.