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.
Step 3: Click the Page Layout tab at the top of the window.
Step 4: Click the Breaks button in the Page Setup section of the Office ribbon, then click the Insert Page Break option.
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
- Open Excel.
- Click the row number or column letter before the page break.
- Select the Page Layout tab.
- 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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.