Can You Create a Page Break in Excel? How to Do It

Yes. In Excel for Microsoft 365 on Windows, select the cell where the next printed page should begin, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected cell and a vertical break to its left; you can inspect and adjust breaks in Page Break Preview.

What a page break does in Excel

A page break tells Excel where to divide a worksheet when it is printed or saved as a PDF. It does not split the worksheet itself, move cells, or add a new worksheet page to the grid. Instead, it changes how the current sheet is divided into printed pages. A sheet may contain many rows and columns on screen but be distributed across several pages on paper.

Excel creates automatic page breaks based on factors such as paper size, margins, orientation, printer settings, and scaling. You can also insert manual page breaks to choose where particular printed pages start. For example, a monthly report might need each department to begin on a new page, even when the previous department’s rows would otherwise leave enough room for part of the next one.

Manual breaks are useful when the natural page division would split a table, separate a heading from its data, or make a printed report harder to follow. They affect print layout only; they do not change formulas, values, or the way the worksheet behaves during ordinary data entry.

Insert a horizontal or vertical page break

The selected cell determines the position of the manual break. A horizontal break goes above the selected cell’s row, while a vertical break goes to the left of its column. This makes it possible to control pages that divide a long list vertically, a wide table horizontally, or both ways.

Click the cell at the point where a new printed page should begin.
Open the Page Layout tab on the ribbon.
Choose Breaks in the Page Setup group, then select Insert Page Break.
Check the result in View > Page Break Preview or use the print preview.

For a simple example, suppose a worksheet has a heading in row 1 and records through row 60. To begin a new printed page above row 31, select A31 and insert a break. To split a wide table before column F, select F1 and insert a break. Selecting F31 can place both a horizontal and vertical break at that cell’s boundaries. A break at the very first row or column does not create a useful division in that direction, so choose a cell farther into the sheet.

The break applies across the worksheet in that direction, not just to the selected cell or a single section of data. If you need a row to repeat at the top of each printed page, that is a separate setting: use Page Layout > Print Titles and specify the rows to repeat.

View, move, and remove page breaks

Page Break Preview is the clearest place to understand how Excel has divided a sheet. Open the View tab and choose Page Break Preview. Excel displays page boundaries and labels the printable pages. In this view, manual breaks are shown as solid blue lines and automatic breaks as dashed blue lines. The exact appearance can vary slightly with display settings.

You can drag a break line in Page Break Preview to change where the page ends. Dragging a boundary can turn an automatically chosen division into a manual one, so review the resulting page layout rather than assuming the change affects only a small area. To return to the ordinary worksheet display, choose View > Normal.

To remove one manual break, select a cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To clear manual breaks from the sheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting removes the manual layout choices and lets Excel calculate automatic breaks again; it does not delete worksheet content.

If you do not see page-break lines in Normal view, switch to Page Break Preview. Excel may also display page breaks in Normal view after a print operation, but that display is not as useful for moving boundaries. Use preview to check which lines are manual and where each printed page will fall.

Make the printed pages easier to read

A page break is only one part of print layout. Before adding several manual breaks, check whether paper orientation, margins, or scaling would solve the problem more cleanly. A wide worksheet may fit better in landscape orientation; a report with a small number of extra columns may need narrower margins. These settings are available from the Page Layout tab, and Print Preview shows the effect before you print.

Use a break when a specific row or column needs to start on a new page.
Change orientation when the sheet is too wide for portrait pages.
Adjust margins when content is close to fitting but is being pushed onto another page.
Scale the sheet when fitting the content to a chosen number of pages matters more than preserving its original print size.
Set a print area when you want to print only a selected part of a worksheet.

To see the print result, press Ctrl+P on Windows. On a Mac, press Command+P. The print screen shows a preview and settings such as page orientation, paper size, and scaling. A page break can put a logical section on its own page, but it cannot make text legible if the sheet is being reduced too much to fit. If the preview shrinks a large table to tiny type, consider printing across more pages instead.

For multi-page reports, repeating column headings is often more useful than adding a break before every block. Use Page Layout > Print Titles, then set Rows to repeat at top, such as $1:$1 for a header in row 1. This repeats the selected heading rows on printed pages; it does not insert a break or alter the worksheet.

How scaling and print areas affect breaks

Scaling can change the page divisions you see. In particular, the Fit to option can compress a sheet to fit a specified number of pages, which may override the effect you expected from manual breaks. If the Breaks commands are unavailable or a break does not appear where you planned, check the scaling controls in Page Layout. Setting width and height to Automatic, or using a percentage scale instead of fitting the sheet to a fixed page count, gives Excel more room to honor manual page divisions.

A print area limits which cells Excel includes in the printed output. It can be useful when a worksheet contains notes or calculations that should stay out of a report. Set it by selecting the cells and choosing Page Layout > Print Area > Set Print Area. Page breaks outside the print area will not help divide the printed selection, so confirm that the area covers the complete report before adjusting breaks.

Changing the active printer or paper size can also alter automatic breaks because Excel calculates the printable space using those settings. If a report looks different on another computer, check paper size, orientation, margins, scaling, and the selected printer before rebuilding all the manual breaks. Use Print Preview or export a PDF to verify the final layout in a format that can be reviewed without sending a test copy to a printer.

Common problems and practical fixes

If Insert Page Break appears unavailable, first check whether the worksheet is protected or whether Excel is using Fit to scaling. Some sheet states and print settings limit page-break editing. Unprotect the sheet if you are authorized to do so, and review the scaling options. Also confirm that you are working in a worksheet rather than a chart sheet, which has different layout behavior.

If a break seems to disappear, it may have been reset, placed outside the print area, or superseded by a scaling choice. Open Page Break Preview and inspect the page boundaries. If the workbook is being printed from Excel for the web, open it in the desktop app for full manual page-break control; the browser version does not provide the same complete tools for inserting and dragging breaks.

Another common misunderstanding is to expect a page break to start a new section in the worksheet. It only changes printed pagination. If you want a worksheet section to be visually distinct on screen, use formatting, a blank row, or a separate worksheet. If the goal is a new printed page, use a break and check the preview so the page does not begin with an orphaned heading or an incomplete table row.

In Excel for Mac, the Page Layout and page-break concepts are similar, although ribbon layout and dialog details can differ by release. Look for Breaks on the Page Layout tab. Excel for the web is suitable for basic editing and printing, but use the desktop version when you need precise manual page-break placement or want to drag break lines.

When to use page breaks instead of alternatives

Manual breaks are best for deliberate page boundaries, not for forcing every worksheet into a single page. If the report has one more column than will fit, landscape orientation or a wider paper size may be preferable. If a list needs to stay together by category, add breaks at the category boundaries and repeat the table headings. If the data is meant to be read digitally, a PDF with sensible page divisions or a shared workbook may be easier than a tightly compressed printout.

For a report that changes length regularly, manual breaks can require maintenance. For example, if a new department is inserted above a planned break, the old division may no longer fall at the right point. Recheck Page Break Preview after adding or removing rows, changing print settings, or updating the print area. Automatic pagination adapts to many layout changes, while manual breaks preserve chosen boundaries until they are changed or reset.

There is no separate charge to create page breaks in the Excel desktop app as part of Microsoft 365; they are a worksheet layout feature. Printing itself may involve printer, paper, or organizational costs, but those are independent of the break command. The key decision is whether exact page control is worth the additional review whenever the report changes.

Frequently Asked Questions

Can I insert a page break in Excel for the web?
For reliable manual insertion and dragging of page breaks, open the workbook in the Excel desktop app. Excel for the web supports basic workbook and print tasks, but it does not offer the same full manual page-break controls as desktop Excel.

How do I insert a page break after a particular row?
Select a cell in the row immediately after the desired division, then choose Page Layout > Breaks > Insert Page Break. For example, to start a new page above row 25, select a cell in row 25. Check Page Break Preview to confirm the placement.

Can I remove just one page break?
Yes. Select a cell below the horizontal break or to the right of the vertical break, then use Page Layout > Breaks > Remove Page Break. Choose Reset All Page Breaks only when you want to clear all manual breaks on the sheet.

Why is Excel ignoring my page break?
Check whether the sheet is scaled to fit a fixed number of pages, whether the break is outside the print area, and whether the current paper size or orientation has changed. Page Break Preview and Print Preview help identify which setting is affecting the result.

Does a page break make a new worksheet?
No. It divides printed output into pages without creating another worksheet or changing the grid. To create a separate worksheet, use the plus button by the sheet tabs or the Insert Sheet command.

Can I add a page break between columns?
Yes. Select a cell in the column immediately to the right of where the new printed page should begin, then choose Page Layout > Breaks > Insert Page Break. Excel places the vertical break to the left of that column.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.