Select the Page Break and move it to the desired column to put all data on a single set of pages by left-clicking and dragging the Page Break. In the bottom left-hand corner of Excel, select the Page Layout view. This will show the page breaks and which data will appear on each page. Select the Layout tab.
If you have an Excel spreadsheet that needs to printed in a specific way, then you may have added page breaks using a similar process to the one outlined. But if you no longer needs the document to print with these page breaks, or if you have received a spreadsheet that contains problematic page breaks, then you might be wondering how to delete them. Excel provides a way to delete page breaks that is very similar to the way in which the page breaks were originally inserted.
So continue reading below to learn how to delete your unwanted breaks. Removing Page Breaks in Excel 2013 The steps below will show you how to delete a page break that is affecting the way that your spreadsheet prints. You will have the option of removing a specific page break, or removing all of the page breaks in the document. Step 1: Open your Excel spreadsheet containing the page break that you want to delete.
Step 2: Click the row number under the page break at the left side of the spreadsheet. A page break is slightly darker that the rest of the gridlines on the spreadsheet. In the image below, my page break is between rows 12 and 13.
Step 3: Click the Page Layout tab at the top of the window. Step 4: Click the Breaks button in the Page Setup of the navigational ribbon, then click the Remove Page Break option. Note that you can click the Reset All Page Breaks option instead if there are multiple page breaks that you want to remove. If you only need to print part of a spreadsheet and are having trouble formatting the document, then will show you how to print a specific set of cells in your spreadsheet. This can be the simplest way to just print part of a spreadsheet without needing to modify many of the page setup and page layout settings.
I might go insane shortly. I have a workbook where, every time I open it, the page breaks have moved. I have never seen this happen before, and since there are two worksheets that have to match up in page count (they are just sorted differently) when printed, it's making me absolutely crazy! Added to this problem is the fact that there are black title bars on each page (they're all different, so I can't just repeat one row at the top of each page to correct this), and I have to keep moving them so I can print the dang thing correctly. What might be causing this?
It's the only time I've ever seen it happen, and I'm so annoyed I'm about to start killing small animals. Help me, please!