Page Breaks in Excel

If you accept a large Excel spreadsheet you lot're going to impress, y'all may want the pages separated at particular spots. 1 mode to practice this is to prepare the print surface area. But another is to insert manual page breaks.

RELATED: How to Print a Worksheet with Comments in Excel

About Page Breaks in Excel

It's best to work with your page breaks in the Page Break Preview in Excel. This allows y'all to run into the automatic and transmission breaks also as the number of pages and their layout.

Go to the View tab and click "Page Pause Preview" in the Workbook Views section of the ribbon.

Go to View, Page Break Preview

You can close Folio Break Preview whatever time past clicking "Normal" on the View tab.

Excel adds automatic page breaks where it believes they vest. You can too add together your ain, as we'll explain, but in that location are a few differences between automated and manual page breaks you should be aware of. An automated break that Excel adds is indicated by a dotted blue line whereas a transmission break that you add has a solid blue line.

Automatic vs. manual breaks in Excel

In addition:

  • If yous move an automatic page break, it becomes a manual break.
  • You cannot delete an automatic page break.
  • If you delete all manual page breaks, this resets the spreadsheet to brandish automatic breaks.

Insert a Folio Suspension in Excel

In one case yous open up Folio Break Preview, yous can fix a vertical break, horizontal break, or both. To insert a vertical page break, select the column to the right of where you desire the break. To insert a horizontal folio suspension, select the row beneath where y'all want the break.

Then, go to the Page Layout tab and click the Breaks drop-downward pointer. Cull "Insert Page Break." Alternatively, you can right-click and pick "Insert Folio Interruption."

Click Breaks, Insert Page Break

Y'all'll see the suspension display with its solid blue line.

Inserted page break in Excel

Continue the same process to insert boosted page breaks every bit needed.

Edit or Movement a Page Break

You can edit a page intermission by moving it to include more or less of your canvas and use additional or fewer pages. Retrieve, if you move an automatic page break, this changes information technology to a transmission pause.

To move a page intermission, click and begin to elevate in the direction you want. You'll see a double-sided arrow and dark grayness line every bit yous practise this. Release when you finish.

Move a page break

If yous want to include the row and column headings or gridlines, you do that exterior of this process. What you see here is simply for the canvass's cell data.

RELATED: How to Print the Gridlines and Row and Column Headings in Excel

Remove a Folio Break

You tin can remove a transmission page break that you insert easily. Select the column to the right or row beneath the break yous want to delete.

And then, caput to the Folio Layout tab, click the Breaks drop-down arrow, and cull "Remove Page Pause." You can besides right-click and choice "Remove Folio Break."

Click Breaks, Remove Page Break

Your sheet volition automatically update to accommodate the remaining breaks.

Removed a page break

If you want to remove all of the folio breaks you've inserted instead of just 1, click the Breaks drib-down box and choose "Reset All Page Breaks." Or, right-click and selection "Reset All Folio Breaks."

Click Breaks, Reset All Page Breaks

Your sheet will and so update to display only automated breaks.

Page breaks in Excel reset

If you decide that y'all only want to print part of your spreadsheet, you can too print a specific selection of cells in Excel.

The above article may incorporate affiliate links, which help support How-To Geek.