Manual page breaks in Excel 2013 can be helpful when you have rows or columns that are printing on the wrong page, or if the naturally-occurring page breaks are in the wrong spot. Unfortunately manual page breaks can become problematic if you add or delete additional data to your spreadsheet, which can result in some odd print behaviors.
Fortunately you can not only add new page breaks whenever you want to, you can also delete them. Our guide below will show you how to remove a page break in an Excel 2013 so that Excel will insert its own page breaks automatically.
How to Delete a Manual Page Break in Excel 2013
The steps in this guide were performed in Microsoft Excel 2013. This guide will show you how to delete a page break, either horizontal or vertical, that was automatically added to your spreadsheet. This will not affect the placement of page breaks that occur naturally when Excel has reached the capacity of the printed page. If you would like to see other options for formatting printed spreadsheets in excel 2013, you can read this guide to printing in Excel.
Step 1: Open the spreadsheet containing the page break that you want to remove.
Step 2: Click in a cell below the horizontal line break, or to the right of a vertical page break. I am removing a horizontal page break in the image below.
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 ribbon.
Step 5: Click the Remove Page Break option.
Tip: If you are having trouble seeing a page break, you can hide the gridlines by clicking the Page Layout tab at the top of the window, then removing the check mark to the left of View under Gridlines.
Are there a lot of manually-inserted page breaks in your spreadsheet, and you would prefer not to remove that all individually? Learn how to remove all of the page breaks from a spreadsheet in Excel 2013 for a method that is a little more complete.