How to Add a Page Break in Excel 2010

Microsoft Excel 2010 will automatically include page breaks in your printed worksheet based on your paper size and margins. Unfortunately these page breaks do not always occur at the best location for the purposes of your data, so you may find that you need to manually add some page breaks to make your spreadsheet easier to read.

Fortunately Excel 2010 offers a simple tool for inserting page breaks that will allow you to control where your worksheet is split either horizontally or vertically.

Inserting a Page Break in an Excel 2010 Worksheet

The steps in this article will allow you to add a page break to your worksheet in Microsoft Excel 2010. if you are using Excel 2013, then you can follow the steps in this guide.

You can add a page break between rows in your worksheet, which will create a horizontal page split, or you can add the page break between columns, which will create a vertical page split. If you wish to create a horizontal page split, then you will either need to select a cell in the first column of your worksheet, or you will need to click on one of the row numbers at the left of the spreadsheet.

Step 1: Open your worksheet in Excel 2010.

Step 2: Select the row number or column letter at the left or top of the worksheet, respectively, before which you wish to add the page break.

For example, selecting row 3 will cause the page break to occur between rows 2 and 3, or selecting column C would cause the page break to occur between columns B and C. Note that you can not insert a page break before the first row or column.

set the location for the page break

Step 3: Click the Page Layout tab at the top of the window.

click the page layout tab

Step 4: Click the Breaks button in the Page Setup section of the Office ribbon, then click the Insert Page Break option.

insert the page break

Now that you know how to add a page break in Excel 2010, you can use these steps whenever you need to adjust the layout of a printed spreadsheet.

Summary – Inserting an Excel Page Break

  1. Open Excel.
  2. Click the row number or column letter before the page break.
  3. Select the Page Layout tab.
  4. Click Breaks, then Insert Page Break.

This article can show you how to remove any page breaks that have been manually added to your worksheet.

If you are adding page breaks because you are having difficulty printing your worksheet, then you should read our guide to Excel printing for some additional tips. There are many different ways to improve the look of a printed spreadsheet, and you can often achieve the desired effect without using manual page breaks.

Continue Reading

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy