Excel Print Page Breaks: How to Insert and Adjust Them

To insert a print page break in Excel for Microsoft 365 on Windows, select the cell below and to the right of the point where you want a new page to begin, then choose Page Layout > Breaks > Insert Page Break. Excel adds a horizontal break above the selected row and a vertical break to the left of the selected column. This lets you control how a worksheet is divided when printed; check the result in Page Break Preview before sending it to the printer.

What You’ll Need

An Excel workbook open in the desktop version of Microsoft Excel. Manual page breaks are best managed in the desktop app; Excel for the web has more limited page-break controls.
A worksheet with its data and print area arranged as you want them. You can insert a break without setting a print area, but defining one first can make the printed range easier to manage.
A printer is optional. Print Preview lets you review page divisions without printing a physical copy.

Step-by-Step

Open the worksheet you plan to print. Select the correct sheet tab at the bottom of the workbook. If the sheet has several sections, decide which rows or columns should appear together and where a new printed page should start. A page break changes the print layout, not the data or its order.
Check the print area and page setup first. If you want to print only part of the sheet, select the range, then choose Page Layout > Print Area > Set Print Area. Also check Page Layout > Orientation and Page Layout > Size. A wide table may fit better on a landscape page, while a narrow list may suit portrait. These settings affect where Excel can place pages, so set them before fine-tuning breaks.
Switch to Page Break Preview. Choose View > Page Break Preview. Excel displays the printable pages against a gray background, with blue lines marking page boundaries. Automatic breaks are usually dashed; manual breaks appear as solid lines. If Excel shows a prompt about page breaks, confirm it to continue. This view is the clearest way to see the effect of a change.
Select the cell that marks the next page’s top-left corner. For a horizontal break only, click any cell in the row that should begin the next page. For a vertical break only, click any cell in the column that should begin the next page. To add both at once, click the cell at the intersection of the desired starting row and starting column. For example, if the next page should begin at row 25, select a cell in row 25; Excel places a horizontal break above that row.
Insert the break. On the ribbon, choose Page Layout > Breaks > Insert Page Break. Excel inserts a manual break above the selected row and to the left of the selected column. If you selected a cell in row 25, the horizontal break is above row 25. If you also selected a cell in column F, the vertical break is to the left of column F. You can add more breaks by selecting other boundary cells and repeating the command.
Review the page divisions and adjust if needed. In Page Break Preview, drag a blue boundary to move a break. Dragging an automatic boundary can turn it into a manual break. Keep related information together where possible, such as a table’s heading and its first rows. Watch the page numbers and gray areas as you move a line; a break that improves one page may create an awkwardly short neighboring page.
Preview the printed result. Press Ctrl+P on Windows, or choose File > Print, to open Print Preview. Check every page, not just the first one. Confirm that columns are not missing, headings are not stranded, and the content is large enough to read. If the layout is wrong, return to the sheet, adjust the break or scaling, and preview again.
Return to the normal worksheet view when finished. Choose View > Normal. The page-break indicators may still be visible on the sheet, but they do not change the worksheet’s values. To remove one, 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 all manual breaks on the sheet, choose Page Layout > Breaks > Reset All Page Breaks.

Common Mistakes

Selecting the row or column on the wrong side of the intended boundary. Excel places a horizontal break above the selected row and a vertical break to the left of the selected column. If you want the next page to start with row 25, select row 25, not row 24. For a vertical break before column F, select a cell in column F.

Expecting a break to change the worksheet itself. A print page break does not split a table into separate sheets, move cells, or add a new worksheet. It only tells Excel where to divide printed pages. If you need to reorganize the data on screen, use worksheet editing tools rather than page breaks.

Adding breaks before setting the print layout. Changing paper size, orientation, margins, or print area can make existing breaks land in unexpected places. Set those options first, then insert or adjust manual breaks and review the pages again.

Confusing a manual break with an automatic one. Excel creates automatic breaks to fit content to the selected paper and scaling settings. A dashed line is generally automatic, while a solid blue line indicates a manual break in Page Break Preview. If an automatic line shifts after you change settings, that is normal; it is not necessarily a break you inserted.

Using too many breaks. Every manual break can create another page, including pages with only a few rows or columns. Check the full sequence of pages before printing, and remove breaks that produce mostly blank or unusable pages.

Tips

Use Page Break Preview for positioning. Normal view is convenient for editing data, but Page Break Preview makes page boundaries much easier to locate and drag. Switch back to Normal when you are done arranging the printout.
Keep table headings with the data they label. If a page begins with data but no column headings, consider adjusting the break or using Page Layout > Print Titles to repeat heading rows on each printed page. Print Titles and page breaks solve different problems: one repeats labels, while the other controls where a page starts.
Use scaling carefully. Under Page Layout, the Scale to Fit options can shrink a worksheet to fit a chosen number of pages. Forcing a large sheet onto one page may make the text too small. If a printout is hard to read, use fewer pages across or down, or return scaling to a less restrictive setting before adjusting breaks.
Check both page directions. A horizontal break controls rows, and a vertical break controls columns. A worksheet with many columns may need vertical breaks even if its row divisions look right. Review the page grid rather than assuming each page contains the whole table width.
Save a copy before substantial layout changes. Page breaks are easy to revise, but a separate copy is helpful when preparing multiple print versions of a worksheet. Give the copy a clear name so you can distinguish it from the working file.

Troubleshooting

The Breaks command is unavailable or does not seem to work. Confirm that you are in a worksheet rather than another workbook view, and try selecting a normal cell in the sheet before opening Page Layout > Breaks. If you are using Excel for the web, open the file in the desktop Excel app for the full manual page-break workflow. A protected sheet or workbook permissions can also prevent some layout changes; if commands are disabled, check whether editing is restricted.

The break appears in the wrong place. Return to Page Break Preview and check which row or column you selected. A horizontal break goes above the selected row; a vertical break goes to the left of the selected column. You can drag the line to the correct boundary, or remove it and insert it again using the correct starting cell.

The printout still has unexpected extra pages. Look for automatic breaks, stray content far from the main table, and a print area that is larger than intended. Select the relevant range and use Page Layout > Print Area > Set Print Area if needed. Then check paper size, orientation, margins, and Scale to Fit settings. Extra pages can result from any of these, not just manual breaks.

A page is blank or contains only a few cells. In Page Break Preview, inspect the blue boundaries and remove unnecessary manual breaks. Also check whether formatting or a stray value in distant rows or columns extends the used print range. If the print area includes those cells, reset or redefine it, then preview again.

The page-break lines disappeared from the sheet. The worksheet may simply be in Normal view. Choose View > Page Break Preview to see the page grid again. If the layout looks correct in Print Preview, the lines being hidden in Normal view do not mean the breaks have been removed.

The printed text is too small after adding breaks. Page breaks do not guarantee a particular text size. Review the Scale to Fit settings and avoid squeezing too many rows or columns onto one page. Consider changing orientation, using a larger paper size, or allowing the worksheet to print on more pages.

Frequently Asked Questions

Can I insert a page break in Excel for the web?
Excel for the web has limited support for manual page-break editing. For dependable control, open the workbook in the desktop version of Excel, insert the breaks there, and use its Print Preview to check the result.

How do I insert only a horizontal page break?
Select a cell in the row that should start the next printed page, then choose Page Layout > Breaks > Insert Page Break. Excel places the horizontal boundary above that row. To avoid adding a vertical break too, select a cell in the first column of the sheet.

How do I insert only a vertical page break?
Select a cell in the column that should begin the next page, then use Page Layout > Breaks > Insert Page Break. Excel places the vertical boundary to the left of that column. Selecting a cell in the first row avoids adding a horizontal break.

Can I move a page break after inserting it?
Yes. In View > Page Break Preview, drag the blue boundary to the desired row or column. Review Print Preview afterward because moving one boundary can change how much content fits on adjacent pages.

How do I remove all manual page breaks?
Choose Page Layout > Breaks > Reset All Page Breaks. This clears manual breaks on the active worksheet. Excel may still show automatic breaks because it continues to divide the printout according to the page setup.

Do these steps work on a Mac?
The desktop Excel workflow is similar: select the boundary cell, then use the Page Layout tab’s Breaks command, and review the sheet in Page Break Preview. Ribbon placement can vary slightly by Mac version. For Print Preview, use File > Print or Command+P; on Windows, the print shortcut is Ctrl+P.

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.