Excel Page Breaks: Set and Adjust Print Pages

To set a 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. Use View > Page Break Preview to inspect and adjust the resulting pages before printing.

How Excel page breaks work

A page break marks where Excel starts a new printed page. Excel adds automatic breaks based on the worksheet’s size, paper size, margins, orientation, and scaling settings. You can also add manual breaks to control the split yourself. A manual break does not change the worksheet’s cells or their on-screen layout; it changes how the selected print area is divided into pages.

In Page Break Preview, the worksheet is divided into numbered pages. Blue lines show the page boundaries: solid lines generally indicate manual breaks, while dashed lines indicate automatic breaks. Excel may recalculate automatic breaks when you change the page setup or add a manual break, so a page boundary that looked suitable earlier can shift after a layout change.

Breaks matter most on worksheets that are too large to print on one page. For instance, a monthly report might need to keep its heading rows with each group of records, or a wide table might need a deliberate split between columns. A page break can improve those divisions, but it cannot make text fit legibly if the print layout is too crowded.

Insert a horizontal or vertical page break

First choose the cell, row, or column that defines the boundary. Excel inserts a horizontal break above the selected row and a vertical break to the left of the selected column. Selecting a cell inside the worksheet can therefore insert both types at once: the new page begins above that cell and to its left.

Click the row number immediately below the place where the next printed page should begin, or click the column letter immediately to the right of the desired split.
Open Page Layout > Breaks > Insert Page Break.
Choose View > Page Break Preview and check that the pages break at the intended rows or columns.
If the result is not right, drag the blue boundary or remove the break and try again.

For example, to start page two above row 36, select row 36 before inserting the break. To start a new page to the right of column F, select column G. A break placed through a table can divide a record across pages, so choose a boundary between complete rows or columns whenever the report’s structure allows it.

If you select a range of cells, Excel uses the active cell in that selection to determine where to place the break. To avoid ambiguity, selecting the specific row or column is usually easier. Excel does not let you place a page break inside a single cell; it divides the print layout between rows or columns.

Move or remove a page break

Page Break Preview is the clearest place to refine a break. Choose View > Page Break Preview, then drag a blue boundary to a new row or column. Moving a boundary changes the amount of worksheet content on the adjoining pages. If you drag an automatic break, Excel turns that position into a manual break.

To remove one manual break, select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. The selected position corresponds to the same boundary used when inserting it. If you are unsure which line is manual, inspect the page divisions in Page Break Preview and select the relevant row or column there.

To remove all manual breaks in the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. This restores Excel’s automatic pagination; it does not erase worksheet data. Resetting can change several printed pages at once, so review the preview afterward rather than assuming the original layout will remain.

Preview pages and check print settings

Page Break Preview is for arranging page divisions, while Print Preview shows how the pages are likely to look on paper. Open File > Print to see the print preview and options such as printer, paper size, orientation, margins, and scaling. Check the preview after editing breaks because the print settings can change the page count and the location of automatic boundaries.

Look at the page numbers and the content at each edge. A useful review checks that:

Headings are not stranded at the bottom of one page while the related records begin on the next.
Important columns are not pushed onto an unintended extra page.
No required rows or columns fall outside the print area.
Text remains readable at the selected scaling and paper size.

If the printed pages contain only part of the worksheet, check whether a print area is set. Select the intended cells and choose Page Layout > Print Area > Set Print Area to define what should print. To clear an existing print area, choose Page Layout > Print Area > Clear Print Area. Page breaks organize printed content within the print area; they do not automatically include cells that have been excluded from it.

Choose between page breaks and scaling

Manual breaks are useful when the content should divide at a meaningful boundary. Scaling is useful when the main problem is that the worksheet barely exceeds the available paper space. In Page Layout, the Scale to Fit controls let you set a width or height in pages. Setting width to one page, for example, can keep all columns together, but Excel may shrink the text substantially if the sheet is wide.

Another route is File > Print, where the scaling menu includes choices such as fitting the sheet on one page or fitting all columns on one page. The exact preview depends on the worksheet and printer settings. Use “fit sheet on one page” cautiously for a large report: it can produce tiny print even though the preview technically shows one page.

Before adding many manual breaks, consider whether landscape orientation, narrower margins, a larger paper size, or a carefully chosen print area would solve the issue more cleanly. These choices affect pagination, so set them before fine-tuning manual boundaries. For a readable multi-page table, a few intentional page breaks are often better than forcing the entire sheet onto a single page.

Keep useful headings on every printed page

A page break controls where a new page starts; it does not repeat column headings automatically. For a long list that spans multiple pages, select Page Layout > Print Titles. In the Page Setup dialog, set Rows to repeat at top to the heading row or rows, such as $1:$1 for row 1. You can also set columns to repeat at the left when a wide report needs identifying labels on successive pages.

Repeated titles are especially helpful when readers will separate or rearrange printed pages. They work alongside page breaks: breaks decide where content is divided, while print titles make selected headings recur on each page. The print preview is the practical way to confirm that the headings repeat as intended and do not crowd out too much of the data.

Common page-break problems

The break seems to move or disappear. Excel recalculates automatic pagination when paper size, margins, orientation, scaling, or print area changes. A manual break may remain, but nearby automatic boundaries can shift. Finish the layout settings first, then review and adjust the breaks again.

The printed pages are unexpectedly small. A setting to fit a sheet or all columns onto a limited number of pages can reduce the scale. In Print Preview, try a wider paper orientation, smaller margins, or more pages across. Do not judge readability only by the number of pages.

A blank page appears. Check whether the print area includes stray cells far from the report, or whether a manual break and scaling setting are creating an extra page. Page Break Preview can reveal the selected print region and its boundaries. Clear or reset settings only after confirming which area should print.

Break commands are unavailable or do not seem to work. Confirm that you are in a worksheet rather than another workbook view, and that the sheet is not protected in a way that prevents the change. Also check the active cell or selected row: the break is inserted relative to that position, not necessarily where the pointer appears to be.

Excel for Mac and Excel for the web

In Excel for Microsoft 365 on Mac, page-break controls are also available from the Page Layout tab, and the view controls provide Page Break Preview. Ribbon wording and window layout can vary slightly by release, but the same basic approach applies: select the boundary row or column, insert the break, and inspect the preview. Keyboard shortcuts for navigating the ribbon differ between Windows and Mac, so using the visible commands avoids relying on a shortcut that may not match your setup.

Excel for the web has fewer page-layout controls than the desktop application. If you need precise manual page-break placement or dragging, open the workbook in the desktop version of Excel. Web printing options can be useful for straightforward jobs, but check the preview and use desktop Excel when you need the detailed page-break controls described above.

Frequently Asked Questions

How do I insert a page break in Excel?
Select the row below or column to the right of the desired boundary, then choose Page Layout > Breaks > Insert Page Break. Check the result in View > Page Break Preview.

How do I remove a page break in Excel?
Select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Choose Reset All Page Breaks to clear all manual breaks on the sheet.

Why is Excel not showing my page breaks?
Switch to View > Page Break Preview to see page boundaries. In other worksheet views, automatic page breaks may be less obvious. Print Preview is also useful for checking how the page layout will print.

Can I make Excel print all columns on one page?
Yes. In File > Print, choose the option to fit all columns on one page, or set the width in the Page Layout tab’s Scale to Fit controls. Review readability carefully because fitting wide content can shrink the text.

Do page breaks repeat column headings?
No. Use Page Layout > Print Titles and specify the heading rows under Rows to repeat at top. Page breaks and repeating titles solve different parts of multi-page printing.

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.