Your sheet will automatically update to accommodate the remaining breaks. Then, head to the Page Layout tab, click the Breaks drop-down arrow, and choose “Remove Page Break.” You can also right-click and pick “Remove Page Break.” Select the column to the right or row below the break you want to delete. You can remove a manual page break that you insert easily.
RELATED: How to Print the Gridlines and Row and Column Headings in Excel Remove a Page Break
What you see here is simply for the sheet’s cell data. If you want to include the row and column headings or gridlines, you do that outside of this process. You’ll see a double-sided arrow and dark gray line as you do this. To move a page break, click and begin to drag in the direction you want. To insert a horizontal page break, select the row below where you want the break. To insert a vertical page break, select the column to the right of where you want the break. Once you open Page Break Preview, you can set up a vertical break, horizontal break, or both.
You can also add your own, as we’ll explain, but there are a few differences between automatic and manual page breaks you should be aware of. An automatic break that Excel adds is indicated by a dotted blue line whereas a manual break that you add has a solid blue line. You can close Page Break Preview any time by clicking “Normal” on the View tab.Įxcel adds automatic page breaks where it believes they belong. Go to the View tab and click “Page Break Preview” in the Workbook Views section of the ribbon. This allows you to see the automatic and manual breaks as well as the number of pages and their layout. It’s best to work with your page breaks in the Page Break Preview in Excel.