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.
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.
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.
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.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.