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. Simply click in a cell below the page break, then go to Page Layout > Breaks > Remove Page Break. You can use a similar method to remove a horizontal page break from a spreadsheet as well.
More Information on How to Remove a Vertical Page Break in Excel 2013
Our tutorial continues below with additional discussion on working with page breaks in Microsoft 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 1: Open the spreadsheet in Excel 2013. 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. The result of this tutorial will be a spreadsheet that no longer has the vertical page break that you have elected to remove. The steps in this guide were performed in Excel 2013, but will work for Excel 2010 and Excel 2016 as well. How to Delete Vertical Page Breaks in Excel 2013 (Guide with Pictures) Our guide continues below with more information on removing page breaks in Excel 2013, including pictures of these steps. Click in a cell to the right of the page break.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.Ĥ Additional Sources Excel 2013 – Remove Vertical Page Breaks Our guide below will walk you through the process of locating and deleting a vertical page break from a 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.
Unfortunately, those manual page breaks can become a problem if you are deleting or adding rows and columns to your spreadsheet. 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. But these page breaks can wind up being in the wrong place, so you may need to know how to delete page breaks in an Excel 2013 spreadsheet. One way to control this is with manual page breaks. But Excel columns and rows can often spill over onto new pages in places that are less than ideal. As you enter information into a spreadsheet in Microsoft Excel you may not be paying attention to how that data will be displayed if you need to print it.