How to Remove a Vertical Page Break in Excel 2013

Manual page breaks in Excel 2013 provide you with the opportunity to let Excel know where it should start a new page when you print. Unfortunately those manual page breaks can become a problem if you are deleting or adding rows and columns to your spreadsheet. If you find that a vertical page break is no longer in the correct spot, then you may need to learn how to remove a vertical page break in Excel.

Our guide below will walk you through the process of locating and deleting a vertical page break from a spreadsheet. You can then either determine where to manually insert another page break, or you can use some of the options in this guide and have Excel automatically fit your columns and rows to single pages.

How to Delete Vertical Page Breaks in Excel 2013

The steps in this guide were performed in Excel 2013, but will work for Excel 2010 and Excel 2016 as well. The result of this tutorial will be a spreadsheet that no longer has the vertical page break that you have elected to remove.

Once you’ve completed this tutorial and are ready to start simplifying the process of comparing data, then something like this subtraction formula in Excel is a great place to start.

Step 1: Open the spreadsheet in Excel 2013.

Step 2: Locate the vertical page break (the vertical gridline is slightly darker) then click a cell to the right of that gridline.

how to delete a vertical page break in excel

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

delete spreadsheet vertical page break

Step 4: Click the Breaks button in the Page Setup section of the ribbon.

eliminate a vertical page break from a spreadsheet

Step 5: Click the Remove Page Break option.

how to remove a vertical page break in excel 2013

Note that you can also elect to use the Remove All Page Breaks option if you have multiple page breaks that you want to get rid of.

Did you manually insert page breaks because Excel was splitting pages at bad spots? Learn how to adjust a spreadsheet to one page in Excel automatically and avoid some of the hassles that you might encounter with manual page breaks. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.