Page breaks in Excel mark where one printed page ends and the next begins
When you print an Excel spreadsheet, the program automatically decides where to split your data across pages. These invisible lines are called page breaks. Most of the time, Excel's automatic placement works fine. But if a page break cuts through the middle of a table, splits related data across pages, or leaves a page nearly blank, you can move those breaks yourself.
Excel shows page breaks as blue dashed lines on your screen when you switch to Page Break Preview mode. You can drag these lines to new positions, or you can set exact break points by inserting breaks manually. The choice depends on whether you want to adjust one or two breaks, or whether you need precise control over where every page starts and stops.
Key Takeaways
- Switch to Page Break Preview mode (View menu) to see where Excel plans to split pages when you print.
- Drag the blue dashed page break lines left, right, up, or down to move them to a better position.
- Insert manual page breaks by clicking a cell and using Insert > Page Break, which gives you exact control over break placement.
- Remove unwanted page breaks by right-clicking the break line and selecting Delete Page Break, or by using Sheet > Delete Page Break.
- Test your changes by using File > Print Preview to see how the pages will actually look when printed.
Switch to Page Break Preview to see where pages split
By default, Excel hides page breaks from view. To see them, click the View menu at the top, then select Page Break Preview. The spreadsheet will shift to a new display mode where page breaks appear as blue dashed lines running horizontally and vertically across your data.
The areas between the blue lines represent the pages that will print. White areas will print normally. Gray areas fall outside the print range and will not print. This visual layout makes it much easier to understand how your data will be divided across pages and to spot breaks that land in awkward places.
To return to the normal view, click View again and select Normal.
Drag page break lines to move them
Once you are in Page Break Preview mode, you can click and drag any blue dashed line to a new position. Click directly on the line itself — the cursor will change to a resize arrow — then drag it left, right, up, or down. Release the mouse when the line is where you want it.
Dragging works best when you need to shift a break by a few rows or columns. For example, if a page break cuts through the middle of a table, you can drag the horizontal break line down so the entire table fits on one page. If a vertical break splits a set of related columns, drag it to the right to keep those columns together.
Excel will adjust the print area automatically as you drag. If you drag a break too far and create a page that is too large to fit on a single sheet, Excel will add a new page break to compensate.
Insert manual page breaks for exact control
If dragging is too imprecise or you need to set breaks at specific rows or columns, insert manual page breaks instead. Click on the row number or column letter where you want the break to start, then click the Sheet menu (or Insert menu, depending on your Excel version) and select Insert Page Break.
A manual page break inserted at row 50 means that rows 1 through 49 will print on one page, and row 50 and beyond will print on the next page. A manual break inserted at column D means columns A through C print on one page, and column D onward prints on the next.
You can insert as many manual page breaks as you need. Each one gives you precise control over where pages split, which is useful when you have a specific layout in mind or when you need to may support certain data always appears together.
Remove page breaks you no longer need
If you inserted a manual page break and later decide you do not want it, right-click directly on the blue dashed line and select Delete Page Break from the menu that appears. The break will disappear when ready.
You can also remove a break by clicking on the row or column where the break sits, then clicking the Sheet menu and selecting Delete Page Break. This method works whether the break is manual or automatic.
Removing a break does not delete any of your data — it only changes where pages split when you print. If you remove all manual breaks, Excel will return to automatic page break placement based on your print settings and page size.
Use Print Preview to check your work before printing
After you move or insert page breaks, always check how the pages will actually look when printed. Click the File menu, then select Print. In the Print dialog, look for a preview pane on the right side of the screen. This preview shows you exactly how each page will appear on paper.
Use the arrow buttons in the preview to flip through each page. If a page break still lands in an awkward spot, close the Print dialog, return to Page Break Preview mode, and adjust the break again. Repeat this process until the pages look the way you want them.
Print Preview is especially useful when you have multiple page breaks or a complex layout. It saves you from printing pages that do not look right and wasting paper.
Reset all page breaks to automatic if you start over
If you have inserted many manual page breaks and want to start fresh, you can reset Excel to automatic page break placement. Click the Sheet menu, then look for an option like Reset All Page Breaks or Clear Manual Page Breaks (the exact wording varies by Excel version). This removes all manual breaks at once and returns control to Excel's automatic system.
After resetting, you can switch back to Page Break Preview mode to see where Excel places breaks automatically. From there, you can insert new manual breaks if needed, or adjust automatic breaks by dragging.
Frequently Asked Questions
Why does Excel keep adding page breaks I did not insert?
Excel automatically adds page breaks based on your page size, print margins, and the width and height of your data. If your spreadsheet is wider or taller than a single page, Excel will split it across multiple pages. These automatic breaks move if you change your margins or page orientation. To prevent automatic breaks, you can adjust your print area or change your page setup settings.
Can I move a page break to a specific cell?
Yes. Click on the cell where you want the page break to start, then use the Sheet menu to insert a manual page break. The break will be placed just before that cell. This is more precise than dragging, especially if you need the break at an exact location.
What happens to page breaks if I add or delete rows?
Manual page breaks stay in place at the row or column you set them to, even if you add or delete data above or below them. If you delete the row or column where a break sits, the break is removed. If you insert new rows or columns, the break shifts to accommodate them.
Do page breaks affect my actual spreadsheet data?
No. Page breaks only control how your data is divided when you print. They do not change the data itself, and they do not affect calculations, formulas, or how the spreadsheet functions. You can move, insert, or delete page breaks without any risk to your work.
Can I see page breaks in the normal view, or only in Page Break Preview?
Page breaks are most visible in Page Break Preview mode, where they appear as blue dashed lines. In Normal view, you cannot see them. If you want to work with page breaks, switch to Page Break Preview. You can always switch back to Normal view when you are done.