How to Insert a Page Break in Excel for Better Printing

To insert a manual page break in Excel for Microsoft 365 on Windows, select the row below or the column to the right of where you want the printed page to split, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected row, a vertical break to the left of the selected column, or both if you select a cell. Page breaks control printed pages and PDFs; they do not divide the worksheet on screen.

What You’ll Need

An Excel workbook with the worksheet you want to print. Save a copy first if you plan to make many layout changes.
Excel for Microsoft 365 on Windows for the full set of page-break controls described below. Excel for Mac has similar controls; Excel for the web has fewer page setup options, so use Open in Desktop App if you cannot find the break commands.
A rough idea of where the printed page should end. Knowing your paper size, orientation, margins, and print area first can help you place the break accurately.

Step-by-Step

Prepare the worksheet for printing. Open the correct sheet and check that the intended content is visible and arranged as you want it. If you only want a particular range to print, select that range and choose Page Layout > Print Area > Set Print Area. If you want the entire sheet, you can skip this. A print area affects which cells are included in print pagination, so set it before fine-tuning manual breaks.
Check the page layout and scaling. On the Page Layout tab, review Orientation, Size, and Margins. In the Scale to Fit group, check whether the sheet is being forced to fit a fixed number of pages. Manual page breaks may not be applied as expected when a worksheet is scaled with the Fit to option. If you need exact manual splits, set the Width and Height controls to Automatic or use an adjusted scale rather than forcing the sheet to fit a page count.
Decide what kind of break you need. To start a new printed page before a row, select the row number immediately below the desired split. For example, if page one should end after row 24, select row 25. To start a new page before a column, select the column letter immediately to the right of the intended split. If the next page should begin both below a row and to the right of a column, select the cell at that intersection. Selecting cell C25, for example, places a horizontal break above row 25 and a vertical break to the left of column C.
Insert the break. With the row, column, or cell selected, open Page Layout > Breaks > Insert Page Break. Excel adds the manual break or breaks to the worksheet’s print layout. If you do not see a visible change in the regular worksheet view, that does not necessarily mean the command failed; use the next step to inspect pagination.
Review the result in Page Break Preview. Choose View > Page Break Preview. The worksheet appears divided into numbered print pages. Manual breaks are shown as solid blue lines, while automatic breaks are generally shown as dashed blue lines. Check that your intended rows or columns fall on the correct pages. You can also use the zoom controls to inspect a large sheet more easily.
Adjust or add breaks as needed. If the split is not quite right, select a different row or column and insert another break. In Page Break Preview, you can drag a visible break line to a new row or column boundary. Dragging an automatic break changes the pagination manually. Avoid placing breaks so close together that they create very small extra pages.
Check the printed pages before finishing. Press Ctrl+P on Windows to open Print, or choose File > Print. Inspect the preview page by page, including the last page, and check for cut-off columns, unexpected blank pages, or headings separated from their data. On a Mac, use Command+P to open the print dialog. Return to the worksheet and adjust breaks or page setup if the preview is not right.
Return to the normal worksheet view. When you are done, select View > Normal. The page divisions may still appear as lines in the worksheet after you have printed or previewed it. Those indicators do not change your data, and they can be hidden through Excel’s worksheet display settings if they are distracting.

Common Mistakes

Selecting the row where you want a page to end instead of the row below it. Excel inserts a horizontal break above the selected row. Therefore, to end a page after row 24, select row 25. Likewise, to break before column F, select column F, not column E. If the line appears one row or column away from your intended spot, remove or move it and select the boundary row or column instead.

Selecting a cell when you only want one direction of break. Selecting a cell can insert both a horizontal and a vertical break. This may unexpectedly split a report into four page sections. Select the row number for a horizontal break only, or the column letter for a vertical break only. Use a cell selection when you genuinely need both boundaries at once.

Assuming a page break changes the worksheet itself. A manual break affects printed output and print preview, not how rows appear while editing or scrolling. It does not move cell contents, create a new worksheet, or add a blank row. If you need visual separation in the data, add formatting or a row; use a page break only to control print pagination.

Ignoring scaling, paper size, or print area. A break that looks correct at one paper size can land differently after changing orientation, margins, or the print range. A fixed Fit to page setting can also override manual pagination. Set up the print area and page layout first, then inspect the print preview again after any layout change.

Tips

Use View > Page Break Preview when placing several breaks. It gives a clearer view of page boundaries than the normal grid and makes it easier to see whether a long table is being split at a useful point. Keep related information together where practical: for example, avoid leaving a column heading at the bottom of one page while its records begin on the next.

For a wide table, a vertical break can help divide columns into separate printed pages, but consider whether readers will need to compare those columns side by side. Landscape orientation or a smaller scale may be more readable than splitting a tightly related table. For a long list, horizontal breaks can place a new section or a sensible group of rows at the top of the next page.

Plan breaks around repeating titles. If a table spans multiple pages, choose Page Layout > Print Titles and set rows to repeat at the top or columns to repeat at the left. Repeating headings makes later pages easier to understand; it is a separate setting from inserting a page break. Preview the result because repeated title rows take up space and can affect how much data fits on each page.

Keep a note of important break locations before changing the layout of a complex report. Inserting or deleting rows, resizing columns, changing margins, or changing the print area can alter automatic pagination and may make existing manual breaks less useful. Check the preview again after those edits rather than assuming the old page divisions still fit.

Troubleshooting

The Breaks command is unavailable or the break does not appear. Confirm that you are working in a worksheet rather than a chart sheet, and select a row, column, or cell in the sheet before opening Page Layout > Breaks. Also check the scaling controls: if Width or Height is set to a fixed number of pages, change it to Automatic and inspect the layout again. If the command is missing in Excel for the web, open the workbook in the desktop application.

The page split is in the wrong place. Confirm that you selected the row below or column to the right of the intended boundary. Then view the sheet in Page Break Preview. You can drag a break line to a different boundary, or remove the misplaced break and insert it again from the correct row or column. Recheck print preview because cell sizes and page settings affect the final printed position.

The preview shows extra pages or blank pages. Look for a print area that includes unused rows or columns, stray content far from the main table, or a manual break that creates a very small page. Use Page Layout > Print Area > Clear Print Area if an old print area is no longer wanted. Then check orientation, paper size, margins, and scaling before inserting breaks again.

The break lines are difficult to see, or they seem to have disappeared. Switch to View > Page Break Preview to inspect the boundaries. If you want to remove all manual breaks and let Excel repaginate, choose Page Layout > Breaks > Reset All Page Breaks. This resets manual page-break placements on that worksheet; review the print preview afterward because Excel will calculate page divisions automatically.

The printed pages differ from the preview. Check that the selected printer and paper size match the settings used for the layout. Printer drivers can report different printable areas, and a change in printer or paper may shift pagination. If exporting to PDF, inspect the PDF itself as well. Make any final adjustments with the intended output device and page settings selected.

Frequently Asked Questions

Does inserting a page break add a new worksheet page?

No. It marks where printed output or a PDF should start a new page. The worksheet remains one continuous grid for editing, and the break does not add rows, columns, or a new sheet.

How do I insert a horizontal page break only?

Select the row number immediately below the desired split, then choose Page Layout > Breaks > Insert Page Break. In Page Break Preview, confirm that the horizontal line is in the intended position.

How do I insert a vertical page break only?

Select the column letter immediately to the right of where the printed page should end, then use Page Layout > Breaks > Insert Page Break. Use landscape orientation or adjust scaling if the resulting pages are too narrow to read.

Can I insert page breaks in Excel for the web?

Excel for the web has fewer page setup controls than the Windows desktop app, and the manual page-break command may not be available there. Choose Open in Desktop App and use the Page Layout ribbon to insert or adjust manual breaks.

How do I remove one page break?

Select the row immediately below a horizontal break or the column immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To clear manual breaks throughout the worksheet, use Reset All Page Breaks instead.

Can I use the same steps on a Mac?

Excel for Mac includes page-break controls on its Page Layout tab; select the relevant row, column, or cell and use the Breaks menu. The print shortcut differs: use Command+P on Mac, compared with Ctrl+P on Windows. Ribbon names or placement can vary slightly by release.

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.